3,889 questions with Microsoft 365 and Office | Excel | For business | Windows tags
DLL file not found when invoking function from Excel/VBA
I'm running Windows 11 with 64-bit MS/Office 2021. I have a very large (>25KSLOC) Excel/VBA application with a helper DLL written in C and compiled by Visual Studio 2022. The last time I used the app was May 4, 2025, and it worked perfectly. Today,…
Microsoft 365 and Office Excel For business Windows
Excel Find & Replace, feedback on
I use Windows 10. This is a feedback post. Excel have changed the appearance of the "pop-up" window that appears after User has used the Find & Replace Dialogue Box. If for example User entered Text A in the Find Box and Text B in the…
Microsoft 365 and Office Excel For business Windows
Feedback on Excel Find & Replace
I use Windows 10. This is a feedback post. Excel have changed the appearance of the "pop-up" window that appears after User has used the Find & Replace Dialogue Box. If for example User entered Text A in the Find Box and Text B in the…
Microsoft 365 and Office Excel For business Windows
Supporting Scribble to Text?
Hi there, I hope this message finds you well. I was reaching out to ask if Excel can or will eventually support Scribble to Text. I use multiple devices at my job and would love the ability to write within Excel cells and it convert to text. I…
Microsoft 365 and Office Excel For business Windows

Run-time error 1004 when creating a pivot table using VBA after Windows Security Patch update
After updating the Windows Security Patch on 06/23/2025, Macros stopped working, and the following error is encountered: "Run-time error 1004: The PivotTable field name is not valid." During debugging, the highlighted code is: 'pivot table…
Microsoft 365 and Office Excel For business Windows
How to fix a macro run time error 1004
When we open the excel file, we get "an error has occurred." It is a macro error # 1004. the error is "Method 'Range' of object'_global' failed.
Microsoft 365 and Office Excel For business Windows
How do I fix a white cross cursor in excel 365
How do I fix a white cross cursor in excel 365? It's on the online and desktop versions for this one user. It's not The Fill handle issue. It's not the mouse. It will not go away.
Microsoft 365 and Office Excel For business Windows
Project Web Access returns dates in empty fields using Power Query
I am using Excel to extract data from Project Web Access using Power Query. I can connect to the PWA database without any issues and extract/manipulate extracted data as I want. However, when planning projects, our project managers leave task dates blank…
Microsoft 365 and Office Excel For business Windows
Fix Access issue
My company just have new PC and when we install all the Microsoft Office software already. But usually, as my old PC, all our company can edit in one file, both Excel and Word. Now, when ever there is another person in the file, and I access that file,…
Microsoft 365 and Office Excel For business Windows
How to Disable the 'Premium Python Compute' Advertisement in Excel 365?
In recent versions of Excel I noticed a new diamond icon in the top right If you click this diamond you get an advertisement for "premium Python compute" How can I disable this advertisement? Steps to reproduce: Open Excel Open a…
Microsoft 365 and Office Excel For business Windows
Best way to generate dynamic forms using AI or Microsoft tools?
Hi, I’m working on a project that requires generating web forms dynamically based on structured or semi-structured content—things like survey specs, user intents, or internal documentation. I know Microsoft Forms and Power Apps allow form creation, but…
Microsoft 365 and Office Excel For business Windows
GETPIVOTDATA() function displaying #REF when opening files in SharePoint browser view
We came across this issue with links that use the GETPIVOTDATA() function when we open SharePoint files in the browser. They display “#REF” instead of the data from the linked workbook. Can you please guide me why this happen? and how to resolve this?
Microsoft 365 and Office Excel For business Windows
how do I sort rows in Excel when one column is blank
Example: Data in columns A, B, C and E. D is blank for now. When I sort rows using the simple Sort & Filter icon, and have selected a cell in column A for the data being sorted (for example, column A has last names), only columns A, B and C sort. …
Microsoft 365 and Office Excel For business Windows
I need an excel formula that automatically updates data from the most recently created tab of another spreadsheet even after adding or deleting rows from the other spreadsheet.
I need a formula for cells in spreadsheet B-column A that will correctly reference cells from the most recently added tab in spreadsheet A-column A, even after adding or deleting rows in spreadsheet A.
Microsoft 365 and Office Excel For business Windows
How to Copy a Workbook in Excel Online Version &/or "Save As" missing + file location not allowed
Unable to "Save a Copy". The "Save As" only allows to "Rename" and DOES NOT allow to "Copy" any longer, as before. When you "Rename" it DOES NOT make a Copy, it just renames the same file. Also the…
Microsoft 365 and Office Excel For business Windows
How to create windows
How to create a Windows in my laptop.... What it excel. Is it possible for me to do cyber trading This question is related to the following Learning Module
Microsoft 365 and Office Excel For business Windows
Live support???????
Would like to talk to a real person. Need to retrieve old files
Microsoft 365 and Office Excel For business Windows
can copilot extract clip name, clip duration, clip file format from a video file and create a table with that information in individual columns in the table?
can copilot extract clip name, clip duration, clip file format from a video file and create a table with that information in individual columns in the table?
Microsoft 365 and Office Excel For business Windows
How do you import data from one excel sheet to another sheet in the same workbook that auto updates?
I need to update a master sheet and have those updates auto update on 3 other sheets in the same workbook. I used the Insert link but it would not update when I inserted a new row in the master sheet. I am trying to keep an alphabetical list of names in…
Microsoft 365 and Office Excel For business Windows
Protect all cells on a worksheet after date has passed
My excel worksheet has tabs for each month in a year (tab names are Jan Yr1, Feb Yr1, Mar Yr1, etc. Worksheets are password protected, but certain cells are not locked to allow data entry. Cell A1 has a different month end date (1/31/25, 2/28/25,…