QUESTION : I’m using Excel and Word in Office 365. I’ve set the Language to Hebrew as my default language […]
Tag: office365
Dynamic Spill-down Formula Fails to Spill
QUESTION : In an Excel 365 environment, I attempt to insert a dynamic spill-down formula: Sub WhyDoesThisFail() Range(“A1”).Formula = “=SEQUENCE(10)” […]
VBA Hide Rows that contain N/A
QUESTION : I have an excel file that has dynamic data that changes daily. For example, a user will populate […]
How do I move a column in an Excel Online Survey Table
QUESTION : In Excel On-line (Office 365), how do I move a column in a table (I don’t just mean […]
Hyperlink to a file using the current user
QUESTION : I am trying to create a hyperlink which will work for everyone on different machines. For example, this […]
Chrome and Microsoft Office 365 and Dropbox
Problem : I no longer have an Office 365 account, but when I click on a document in Dropbox in […]
“Too many arguments” error message in SUMPRODUCT
QUESTION : I’m somewhat newer at this, so I apologize if this is a dumb question. I want to count […]
Summarize data using pivot table
QUESTION : I am trying to review the budget for our department at work, but it is an insane amount […]
How to set value of height or width of cell precisely? – ms excel Office 365
QUESTION : I’m going to make labels for pasting in MS Excel Microsoft Business 365. I have version 1903 (compilation […]
Enrich source data for use in a pivot table
QUESTION : In Excel we use one worksheet, the SourceSheet where data from another system is copied into by my […]