19,984 questions with Microsoft 365 and Office | Excel | For business | Windows tags
Increase font size in excel formula bar
After recently upgrading to W11, I note that the font size in the excel formula bar is now tiny (I'm having trouble reading it). How can I change the settings to increase it permanently?
Microsoft 365 and Office | Excel | For business | Windows
Open Excel window will not show on screen.
I have an Excel file open on my desktop, but the window is not visible and will not maximize. I need this file.
Microsoft 365 and Office | Excel | For business | Windows
Variable Excel "Connecting to Datasource" Load times
Hello, I am running into a strange issue that I am not sure how to solve. I am using Power Query to link to external Excel data files/Sheets and then I process the data within Power Query and also have some Macros that run after the data is refreshed. I…
Microsoft 365 and Office | Excel | For business | Windows
My Search/Replace doesn't work?
My Search/Replace doesn't work? I select a range of cells that clearly contain what I'm searching for but Excel returns not found? I have a macro in my sheet that uses the VBA replace function, its triggered by a key press and far too large to post here,…
Microsoft 365 and Office | Excel | For business | Windows
SPILL ERROR on function
I can't get this function to work: =SUMPRODUCTIFS(($C2:$C141="KS")($D2:$D141="STEER"), $I2:$I141, L2:L141)/SUMIF($I2:$I141,($C2:$C141="KS")($D2:$D141="STEER")) Giving me a spill error or saying too few arguments...
Microsoft 365 and Office | Excel | For business | Windows
Excel document should have been locked while I was working on it, another user somehow accessed the document.
While working on an excel document and attempting to save I received the message: ""File Name" may have been changed by another user since you last saved it." when saving, I had to make a tmeporary copy to keep my work. Another user…
Microsoft 365 and Office | Excel | For business | Windows
How do I enable macros in a CMMC level-2 setting
I have a comprehensive macro-imbedded document that came from a non-governmental entity that I am trying to open on my computer which has CMMC settings on it as a government contractor. Nothing within the file is a breach of any sort of government…
Microsoft 365 and Office | Excel | For business | Windows
Where do I see my tickets?
Good Morning , Will you be able to send your reply from my last question. I cannot find it in my inbox. is there a way to see all my tickets? It was about PV table unable to refresh it. Thanks, Therence
Microsoft 365 and Office | Excel | For business | Windows
How to permanently disable Chart Styles in Excel
When opening larger excel files with a chart containing thousands of data points, it takes several MINUTES to open the file, because the Chart Styles are loading with all the possible styles for that particular chart. I tried removing Chart Styles from…
Microsoft 365 and Office | Excel | For business | Windows
IF Statement comparing text
When comparing string value in an IF statement, does it matter if the string is all uppercase or not? EXAMPLE: IF lastname = "Doe" OR lastname = "DOE" Then..... I am just wondering if it matters or do I actually need to check both…
Microsoft 365 and Office | Excel | For business | Windows
excel doesn't allow me to save changes
Since installing 365 I can not save excel sheets with changes?
Microsoft 365 and Office | Excel | For business | Windows
How do I change the background of an Excel formula bar?
Need to see formulas more easily and black forces me to highlight the bar. This is not optimal
Microsoft 365 and Office | Excel | For business | Windows
Help with Prioritizing Excel Conditional Formatting
Hello all, I was asked to create a spreadsheet in which the dates entered in different cells cause them change colors. The first thing asked was to have the cells in Column G turn red when the date entered is older than today's date, turn orange when…
Microsoft 365 and Office | Excel | For business | Windows
Microsoft Excel - Print row 1 as the title on each printed page.
Microsoft Excel: I need to print row 1 on each page of a report when I am printing a spreadsheet. Much like the "Freeze pains for row 1" but when you print.
Microsoft 365 and Office | Excel | For business | Windows
How to use Excel add-in
Hello trying to assist a user with a excel add in called Nielsen Connect. https://marketplace.microsoft.com/en-us/product/office/WA200002856?tab=Overview When adding the add in and trying to access it we just get an error
Microsoft 365 and Office | Excel | For business | Windows
HOW TO FIX THIS ERROR UPLOOKX MULTIPLE CRITERIA
Hello everyone, Could anyone explain to me why this formula is not working, please? Image 1 formula works. Image 2, with the same formula, doesn't work. Why?
Microsoft 365 and Office | Excel | For business | Windows
SUMPRODUCT error
=SUMPRODUCT((M1:HU1="hour")*(M5:HU5)) its giving me a value error and I cant seem to figure out why, or is there a better way of getting the sum of the total month? =SUMPRODUCT(($K$1:$CJ$1="out")*(K5:CJ5)) it works on this sheet,…
Microsoft 365 and Office | Excel | For business | Windows
A Change in Excel not allowing sorting in pivot tables.
In creating a pivot table in Excel, the ONLY column you sort is the first column, I can no longer sort on any other columns. I do have a column that has grouping but I am not allowed to ungroup and can only sort by the first column which is my grouping…
Microsoft 365 and Office | Excel | For business | Windows
Unable to determine how to enable a macro
I have an excel document with an embedded macro. It worked for years. Now recently, it is being blocked by security protocols. I understand my company has security protocols, 100%. I am trying to see where the "trust this document/trust this…
Microsoft 365 and Office | Excel | For business | Windows
"Untrusted" excel macro - but it's not untrusted and I'd like to have my laptop recognize that. How?
I regularly use an excel file that utilizes a macro. I've used it for years, and it still works for the rest of my team, but since I received a new laptop, I'm getting the error suggesting a security risk due to: "..because the source of this file…