Content
Indirect Formula - (Excel Online Version)
Hello, I'm trying to add an indirect excel formula in an online excel file. I need to link the indirect formula to other external online excel files. Basically, we have individual files by location that track performance. I'm creating a new…
How to send only one email using Power Automate based on a condition in different rows in Sharepoint Excel?
I am trying to send just one email to a particular user in Power Automate, where the program runs through all the rows in an Excel file, and based on a condition, adds the particular rows to a table, which it then sends to the user altogether. So far, I…




Microsoft should FIX - "Errors were detected while saving (filename)"
Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019. "Errors were detected while saving (filename).…


MS edge > Excel not running > error(Unsupported browser)
Windows 10 Microsoft Edge 109.0.1518.78 지원되지 않는 브라우저 Office는 최신 브라우저 기술을 사용하며 최신 브라우저에서 최적의 성능을 나타냅니다. 브라우저를 업그레이드하세요. Unsupported browser Office uses the latest browser technology and performs best in modern browsers. Upgrade your browser. This issue…


Open macro provide an odd error message
Upon opening error message: Compile error: Expected End Sub I am definitely at a loss. Below is the code. This code works fine outside the open macro. Private Sub Workbook_Open() Sub UnProtectAllSheets() Dim ws As Worksheet For Each ws In…


2D Map Chart
I am using Office LTSC Pro Plus 2021 x64 Multilingual, installed a Week ago Issue: Data tab > Data Types > Geography is not available in MSEXCEL and I am unable to create city name wise 2D Map chart, currently its only Province Or State Or Country…


some message get garbled after adding disclaimer to a message
Dear experts, After I added an external message disclaimer via transport rule, some of our external message get garbled. I have confirmed that it's called by the disclaimer because when I disable the rule, everything is OK. below are the disclaimer and…
Need some help with my office script code
Hi, I need my code to run only in AC5:AC column but it runs in every cell, not sure what the problem is, where's my code: function main(workbook: ExcelScript.Workbook) { // Get the specific sheet in the workbook. let sheet: ExcelScript.Worksheet =…
Importing excel workbook data into MS Project isn't working
Hi When I try to import excel data into MS Project, I have to select the tab name (which I haven't had to do before if there is only one active tab), but when I try and select the data - nothing is showing. I have cleared all formatting from the…


TEXT formula
Mark 1, 2, 3, 4 and so on for every 10000 accumulated customer amounts in column D, and the results are listed in column E
Multi-conditional search returns non-duplicate values
Returns the non-repeating value of column A according to the date and name
SharePoint file is downloaded instead when opened in Desktop App
Hello! I have a company laptop and we have Microsoft 365 licenses. In my previous company laptop, whenever I open a file in SharePoint, it opens in browser and then if I want it opened in Desktop app, I just click Editing > Open in Desktop App and…


Excel: Exporting Show Changes Log
Hello all, it was suggested by a Microsoft Community Mod that I ask this here: I have a SharePoint-stored Excel file that is used by my team to store which local restaurants are open on any given day, where the rows are the restaurants and the columns…


How to fix excel student account credential?
Hi Unfortunately, I just disabled my student credential for excel. From managing device options I disabled it. Please help me with this. How can I fix this issue?


Excel: How can I add "Last Modified" to Excel
Excel: How can I add "Last Modified date" in a cell on an Excel spreadsheet every time I save it? Office 2019


Is there a difference in Excel 2007 and Excel 365 with respect to Visual Basic Macros?
I have a spreadsheet with Macros that was created in excel 2007. It will not run correctly on my machine with Excel 365.


I don't see the Automate tab in the Office Excel.
I need an Automate tab to use macros in Excel. But I don't see it. I can't even see the option Please help me. ]1
PivotTable in Excel
Hi All, I'm using a tabular model in Excel, everytime i add a filter, row or column in the PivotTable, the excel tries to execute the query to refresh data. Since our tabular model is full of data and dax, it takes time every time the excel refresh…


merge excel files
How to merge several Excel file into one worksheet in Excel?

