Word Excel in Microsoft 365 subsciption is not working properly
Word Excel tool in Microsoft 365 subscription is not working properly. Can someone help me
Issues connecting Onedrive Excel sheet to third party app
To start off, I want to say that I am in no way a developer or know any coding. So forgive me if I am unable to explain this efficiently. Here is what I am trying to do: I build a very basic app with go.glideapps to show all the vehicles i have. The data…
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…
Recommended approach to adding web pane to Excel worksheet
We are using the Javascript API to write an Excel add-in. The app runs well in the task pane. We are making good headway on that, but there is a specific feature we want to support that is challenging to find an answer for: How can we utilize the…
How to Default name of the user who signed in to an Excel field
Hi, I want to default name of the user who Signed in to an excel field and make it non editable. If user not signed in, prompt as 'Please Sign In'. Please advice how to do it. Regards, Sudheer.
ボリュームライセンス版のExcelとOffice 365 Apps for enterpriseのExcelの終了処理の違いを知りたいについて
ボリュームライセンス版のExcelとOffice 365 Apps for enterpriseのExcelで Excel.exeの終了処理に違いはあるかご教示いただきたくお願いします。 終了までの時間を比較したところOffice 365 Apps for enterpriseのExcel版がボリュームライセンス版の Excelより約3秒~6秒ほど遅い場合があるためその理由を知りたく質問させていただきました。 宜しくお願いいたします。
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…
Refresh of Exported SharePoint list keeps failing
I have a report set up in Excel that is linked to a SharePoint list and it worked fine for weeks. But recently when I now click Refresh All, I get a message saying 'a connection to the SharePoint sire cannot be established. To synchronise or refresh your…
Resize table using VBA
Hello, I currently use the following code in order to copy data to another worksheet. However, when I eliminate rows on the original worksheet, the range of the table for the second worksheet remains the same when I run the macro. I was wondering if…
how to remove auto group window
how to remove this, I don't want this auto group and add another window too many function and lag, too slow when i want to change my work book. if i want another group from a-b to a-c? y create auto group?
Workbook.refreshAllDataConnections() is not supported in Power Automate.
Dear all, I have an excel sheet with an active connection which I am able to refresh to get the newest data. Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be…
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…
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