
19,184 questions with Microsoft 365 and Office | Excel | For business | Windows tags
How can cloud-based solutions ensure data security while handling sensitive valuation reports for NPAs or TEV studies?
I work in the valuation industry, where we frequently prepare and exchange highly sensitive reports such as Non-Performing Asset (NPA) valuations, Techno-Economic Viability (TEV) studies, and Lenders Independent Engineer (LIE) reports. These documents…
Microsoft 365 and Office | Excel | For business | Windows

excel unable to change font and color
Recently i can't change font size, font color as well as cell color. Whenever the color i change, it will either become black, or dark blue or sometimes light grey. Try all the suggested solution but nothing had changed. Im using office 365 excel version…
Microsoft 365 and Office | Excel | For business | Windows

Retain zeros in a cell
How do I enter a number but retain the zeros at the beginning? The numbers will all be different lengths - I thought of creating a custom number but can't get it to work. TIA
Microsoft 365 and Office | Excel | For business | Windows

How to adapt a formula to create a gantt chart reflecting days, not weeks
I am working in an existing Gantt chart file which has been shared with me. It's original function was to round the time between 2 dates to the nearest full week and show this in the Gantt chart. I would like to adapt this formula to represent days,…
Microsoft 365 and Office | Excel | For business | Windows

Call Center Question: How do I calculate the "weighted average" of "abandoned rate %" highlighted in yellow
Microsoft 365 and Office | Excel | For business | Windows

Editing template calendar from 2025 to 2026
I am trying to change the calendar setting in an excel template from 2025 to 2026. This is the formula: =IF(MONTH(TODAY())=12,YEAR(TODAY())+1,YEAR(TODAY())) How can I change it to 2026 for all the tabs? The template is Any year calendar (1 month per…
Microsoft 365 and Office | Excel | For business | Windows

Excel on web, script buttons say they are running, but they dont. (For over an hour)
I have had a "Excel" template running for months. Simple copy of hidden sheet to primary sheet. Has been running faithfully for months. Now, scripts simply will not run. The buttons do nothing, as well as the script library. Says setting…
Microsoft 365 and Office | Excel | For business | Windows

This file can't be previewed because of an error in the Excel Preview Handler
This file can't be previewed because of an error in the Excel Preview Handler
Microsoft 365 and Office | Excel | For business | Windows

I can't save any documents in Microsoft 365
Hello Please i need your help on this issue. I cant save any document in Microsoft 365. ' When i try to save a document in word or excel i get the error below
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Word | For business | Windows

Microsoft 365 and Office | Excel | For business | Windows


Import named TABLES (not RANGES) from Excel to Access
So I've referenced this issue several years ago access-2016-import-from-excel-2016-table-names-do-not-show-up) I have not been able to Google anything new on this topic so I thought I'd try to bring it up again to see if there is any new information.…
Microsoft 365 and Office | Access | Development

Microsoft 365 and Office | Excel | For business | Windows


I just lost several days of work in Excel following a Microsoft excel update syncing problem in OneDrive
My file was saved in OneDrive with autosave on. A yellow strip across the top saying Microsoft has updates and the next time I saved the file it said "merging error" or something and "cannot display merged content" and half of the…
Microsoft 365 and Office | Excel | For business | Windows

Need an Office script function to suppress/ enable subtoals only for a particular row value in an excel Pivot Table
I have a scenario where i want to create a pivot table using office script. For example below it the data Based on this data i need to create a pivot table, but i want to hide the highlighted state level subtotals. The subtotals can be hidden…
Microsoft 365 and Office | Excel | For business | Windows

Copying filtered data to an Excel table directly is very slow
Let say I want to copy the data in row 1, 5, 10,15 and 20 (5 rows) of a table in File A to an Excel table in File B. The auto-add-new-row-to-table feature will be triggered 5 times, making the pasting process very slow. Now, imagine it's 50 rows I'm…
Microsoft 365 and Office | Excel | For business | Windows

Macro is causing Word to freeze and crash
There is a Macro that we run in Excel, which has been around for 15+ years. It takes the data, adds capitalizations/punctuations, and the very last step is generating a Word document. Unfortunately, as of the last 2 months it is causing Word to freeze…
Microsoft 365 and Office | Excel | For business | Windows

how do i create a pivot table for this MOM by agent AHT
Microsoft 365 and Office | Excel | For business | Windows

Office Script Buttons not Responding
After a recent Microsoft Excel for Online update, buttons for my office scripts have stopped working. when I click them, a banner comes up saying that it is being initialized. They work fine when ran from the automation tab or code editor. I want to know…
Microsoft 365 and Office | Excel | For business | Windows

Trouble in running OfficeScripts in Excel Online Sharepoint
I hope you are all doing well. I'm reaching out to bring to your attention an issue I've been encountering with running Office Scripts on Excel Online in SharePoint. While the script functions perfectly on the Excel desktop application, I keep receiving…
Microsoft 365 and Office | Excel | For business | Windows

Binding an excel forms textbox exit event to a class module
I am having trouble binding a series of textboxe exit events on an excel form to a class module; Here is My class code: Public WithEvents myEBtn As MSForms.TextBox Private Sub myEBtn_end(ByVal Cancel As MSForms.ReturnBoolean) 'MsgBox…
Microsoft 365 and Office | Excel | For business | Windows

How to fix an issue where a black bar is covering my sheet tabs in Excel
In Excel within Citrix, a black bar appears at the bottom of the window, obscuring the sheet tabs. This issue occurs across multiple workbooks and machines, making it difficult, but not impossible, to navigate between sheets. I have attached a screen…
Microsoft 365 and Office | Excel | For business | Windows

Excel Lookup Function help
Hello, I have an excel output from an ERP system that's not great with functionality. I need to sort the dataset using a function to separate out variables. Currently all variables go into the "TEST RESULT" Column with the "CHARACTERISTIC…
Microsoft 365 and Office | Excel | For business | Windows
