19,184 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
3 answers

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
asked 2025-08-25T05:59:04.32+00:00
Shivani Sharma 0 Reputation points
commented 2025-08-29T01:38:31.5166667+00:00
Sting-Ng 3,810 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-08-28T04:07:15.5+00:00
Eric Sin Han Wei 0 Reputation points
commented 2025-08-29T01:15:29.11+00:00
Eric Sin Han Wei 0 Reputation points
2 answers

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
asked 2025-08-27T13:54:01.2866667+00:00
Louise Wooding 0 Reputation points
commented 2025-08-29T01:14:30.79+00:00
Sting-Ng 3,810 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-08-27T02:24:46.17+00:00
BCW 0 Reputation points
commented 2025-08-28T23:51:58.7466667+00:00
Sophie N 2,445 Reputation points Microsoft External Staff Moderator
asked 2025-08-26T12:21:28.4333333+00:00
Carrie Ward 80 Reputation points
commented 2025-08-28T22:40:11.4033333+00:00
Barry Schwarz 3,916 Reputation points
2 answers

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
asked 2025-08-26T16:06:43.9033333+00:00
Ray Lasorsa 0 Reputation points
answered 2025-08-28T22:38:12.6533333+00:00
Kai-L 2,345 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-08-26T20:34:25.4833333+00:00
Robin Ganderton 76 Reputation points
commented 2025-08-28T21:35:32.59+00:00
Killian-N 2,230 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-08-26T21:32:34.53+00:00
EL 0 Reputation points
answered 2025-08-28T21:21:05.2466667+00:00
Hani-N 2,080 Reputation points Microsoft External Staff Moderator
3 answers

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
asked 2024-03-27T11:58:46.4566667+00:00
IniobongNkanga-8038 981 Reputation points
edited a comment 2025-08-28T19:29:53.67+00:00
Stefan Blom 310.3K Reputation points MVP Volunteer Moderator
3 answers

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
asked 2022-11-09T18:43:39.953+00:00
Dom 951 Reputation points
commented 2025-08-28T13:44:50.3366667+00:00
George Hepworth 21,900 Reputation points Volunteer Moderator
1 answer

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
asked 2025-07-05T02:27:56.53+00:00
Siderius, Naomi Louise - sidnl002 5 Reputation points
commented 2025-08-28T09:34:59.7966667+00:00
Stewart Manjoro 0 Reputation points
1 answer

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
asked 2025-08-26T10:07:07.8366667+00:00
Shweta Pradhan 0 Reputation points
commented 2025-08-28T08:51:45.66+00:00
Jess-Q 1,420 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-08-26T06:55:47.3+00:00
racaywt 20 Reputation points
edited a comment 2025-08-28T08:10:49.11+00:00
Phoebe-N 2,055 Reputation points Microsoft External Staff Moderator
4 answers

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
asked 2025-08-04T17:38:30.4833333+00:00
Lisa C 0 Reputation points
answered 2025-08-27T21:13:22.3+00:00
Jay Tr 1,295 Reputation points Microsoft External Staff Moderator
4 answers One of the answers was accepted by the question author.

how do i create a pivot table for this MOM by agent AHT

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-08-26T15:04:45.81+00:00
Carrie Ward 80 Reputation points
commented 2025-08-27T16:58:28.6733333+00:00
Hendrix-C 2,050 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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
asked 2025-08-27T13:52:54.5333333+00:00
Jamie Hubble 20 Reputation points
accepted 2025-08-27T15:39:18.8033333+00:00
Jamie Hubble 20 Reputation points
1 answer

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
asked 2025-08-19T10:19:09.6066667+00:00
Anu Tomy 0 Reputation points
commented 2025-08-27T13:37:44.7033333+00:00
Liora D 2,495 Reputation points Microsoft External Staff Moderator
8 answers One of the answers was accepted by the question author.

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
asked 2025-08-21T13:39:47.0666667+00:00
Alex Baja 21 Reputation points
commented 2025-08-27T12:40:19.9266667+00:00
Alex Baja 21 Reputation points
19 answers One of the answers was accepted by the question author.

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
asked 2025-08-11T09:53:40.88+00:00
Connor Otterbeck 80 Reputation points
commented 2025-08-27T08:04:14.9733333+00:00
Connor Otterbeck 80 Reputation points
1 answer One of the answers was accepted by the question author.

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
asked 2025-08-22T16:05:45.74+00:00
accepted 2025-08-27T07:24:02.3966667+00:00