how do I change the language on my Microsoft apps?
My Microsoft word and excel changed to Spanish - how can I fix that?
Excel crashes when opening a macro enabled excel file intermittently
I have an issue with a macro enabled excel file crashing intermittently. The file starts as a blank template for users to add data, sheets and images to. They can make copies of the template file. But every so often we run into an issue with certain…
Why is my multiplication formula in Excel giving me a time and not a ?
I'm working through Project 1 of the Excel training linked here within the Course Materials. I'm on section "4.1.1 Insert relative, absolute, and mixed references" Within the Educator Materials, it provides instructions on how to complete the…
Why are my Ctrl - and Ctrl + shortcuts (delete and insert cells) not behaving properly
I have multiple versions of the same file. I thought that the latest ones got corrupt at some point and Ctrl - wasn't working. All it did was delete the cell contents instead of deleting the cells. So i started testing for the latest non corrupt file and…
Practice tests for MO-110 and MO-210
Hello, I plan on studying for the certification exams MO-110 and MO-210. Where can I find free practice exams for these? Also, I have already practiced for MO-110 using the practice files by Microsoft but could not find anything for the Excel exam…
How do I resolve vba error 1004 when trying to autofill using a variable for dynamic range?
I get error 1004 on this line of Excel vba code and don't know how to resolve. Selection.AutoFill Destination:=Range("R2:R" & lastRow) Dim wb As Workbook Dim ws As Worksheet Set wb = ActiveWorkbook Set ws =…
Excel document in shared server folder, opened by another user
Good morning, I wanted to ask if any of you have ever encountered the following problem. If a colleague opens an excel document, which is on a shared folder on a file server, the following error appears: File in use Open Read Only or click Notify to…
Programmatically read restricted excel file
I have a series of Excel's that are protected by the business. I have the required permissions to view the file manually however I would like to create a programmatic way to extract the data from these excels. I have tried using Python to read and…
In Excel, my developer tab is missing from my bar
The Developer tab where I go to my macros is missing. It was there yesterday and now it's gone. How do I get that back?
Error 53 - how to fix
Brand new Mac mini purchased today - installed Office 365 with my work credentials and met with this on start-up
Files that are encrypted through the sensitivity label.
Hello Please i need your help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I've opened the Excel file on my MAC that is in my downloads folder. This issue looks to be on all files…
Bad Request - Request Too Long, when inserting image in header
When I try to insert an image in header o footer, in Excel, the folloing image pops Up: "Bad Request - Request Too Long HTTP Error 400. The size of the request headers is too long."
How do I prevent emf, dat and tmp files creation when printing out excel files?
I made a program that runs multiple printers and print out a lot of materials a day - more than 3,000 sheets. As long as I know, the emf, dat and tmp files are all the temporary files that should be deleted after the task is over but somehow, these…
some questions about Microsoft Barcode Control 16.0 in excel
Is the QR codes made by Microsoft Barcode Control 16.0 always valid or is there a time limit?Can QR codes be scanned unlimitedly? Or does it become invalid after a few scans?
Sharepoint Validation for Multiple Actions and Multiple Target Dates
I have a list that comprising of 6 Action columns that when they have a text entry a corresponding Target column then requires a mandatory Target date. These work for the Action and Target but I can't get the formula for more than once action. …
Excel script executable by button in workbook once only once, but fails with an error "the button cannot run since the script was unshared. Contact the owner to share it again" when clicked twice.
Created an excel script, and added a button to the excel workbook. This script is owned by and linked to my account. But since the workbook is accessible to my whole organisation, people are able to execute this script by using the button added. While…
Creating a link from a word doc to a specific excel cell
Hi, I'd like to create a link from a word document to a specific cell in a workbook sheet. I have tried \ work book address #gid=.'pagename -'!$A$160. which initially takes me to the correct cell but I get a pop up box saying "reference isn't…
How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application
Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su*****sk@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try signing…
Formula for highlighting overdue date (or days from due date) from varying due dates
Hi I am trying to creadte a spreadsheet to monitor document reviews and to highlight when a document review is overdue. However documents are reviewed at different dates and I don't have the review dates for each document as yet as this will vary across…
Excel 16.85 is having permission issues
Hello Please i need your help on this issue. The newest version of Excel 16.85 is having permission issues with opening encrypted Excel files I am able to open the file while on 16.84 then when I update to the latest update 16.85 I would get the…