Is there a way to disable the script confirmation popup the appears everytime I click on a button?
I create a simple file and I was trying to automate some processes and I notice that every time I click on the Script button it shows me a popup on the right side that says script run status, its annoying to see that everytime I click on the button. How…
Attempting to save Options always results in error message "the end date you entered occurs before the start date"
Problem is ... In Outlook, File | Options, any attempt to save by clicking the OK button (even if you have made no changes) results in the error message "the end date you entered occurs before the start date" and no changes to the Options can…
Can I retain formula results if background data changes?
To Note I tried like 30 times to post this in the Excel Forums and keep getting some random error. I have a workbook with lets say 4 sheets. A-Coversheet B-Requirements Tracker C-Services D-Software Sheets A, C, and D have rows…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
VBA Macro for PowerPoint to format videos
I 'm trying to format automatically all the videos in a PowerPoint presentation doing the following: Maximize the size of the video in the slide. Center the video in the slide. Playing the video in a continuous loop. Playing the video…
How to fix error Access to image at '....' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
At my work, our websites sends daily emails with images of reports that are linked to the website itself. It was doing this just fine up until yesterday, however starting today, the images don't show up at all. (see image below) This only happens when…
Help with "DataPivotHierarchy setSummarizeBy: The argument is invalid or missing or has an incorrect format." error
I have an excel script which used to run with no problems. Suddenly I'am getting an error when trying to set a column to summarise by average in a pivot table. I get the following error: DataPivotHierarchy setSummarizeBy: The argument is invalid or…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
VSTO desktop add-in connectivity with Azure Resources
Is there a way for VSTO desktop add-in to connect with Azure resources such as Azure Storage and Cognitive service via Azure Managed Identity authentication? Edit: Is there anyone who can help me reach out to the VSTO/Office desktop add-in support team?
My developer account expired
Hello, In October of last year I registered for a developper subscription for a project I was working on. As the development on that project got paused, my subscription expired. Yesterday I got told that dev on that project would restart but I saw that…
why Excel VBA modules are not getting saved?
Hello All, I am working on development of a project specific excel tool and I am stuck on one issue. I am facing an issue in saving the modules which I create in Visual Basics Window. The modules gets discarded every time I close the excel and reopen…
I need a simple and elegant solution to export a detailed audit of all changes to an Excel Online file.
What I'm looking for is a report that shows the same format as the legacy "Track Changes" function, but in a modern environment. I believe the best way would be to aggregate all of the changes that are listed by the "track changes"…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Need help on reactivaing my microsoft 365 developer Sandbox
Hi All, Last year in November i signed up for 365 developer community and i was given the E5 Instance Sandbox for development due to some issues i have left the program after developing the powerapp and integrated it with teams. After completion of my…
Unable to set my 'Busy Status' in outlook when replying to a meeting invite?
I can't seem to set my 'busy status' (free, busy, out of office etc) during the 'response' screen when replying to meeting invites. Do I need to manually set this for each meeting by selecting from my calendar after responding to the email invite? I am…
How do I get the program past the "modify setup" box?
I have some documents from Veterans Affair that need downloaded, but when I use the link they provided for Azure info protection they program is stuck on a box with "modify setup" and I can't use the program to download the documents. Please…
dynamic add label to userform and click event
I want to dynamically add multiple labels to a userform and then capture the click event to run a macro based on the name of the label. I figured out how to add the labels but not the click event. Thank you in advance. :-)
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
HCL notes links in new outlook and outlook in the edge browser no longer work
HCL notes links in new Outlook and outlook in the Edge browser no longer work. (using outlook in chrome and firefox the links work as expected) Clicking on a link like this within outlook (which goes to the URL notes://server/db/0/doc) does nothing. When…
microsoft visio viewer was not able to complete the operation - vba in excel
I am using the Visio Viewer Active X control in excel. When I try using the following method I get the message "microsoft visio viewer was not able to complete the operation" Sheet1.ViewerSMG.Load…
![](https://techprofile.blob.core.windows.net/images/JiX-lf2_BgAAAAAAAAAAAA.png?8D8532)
Vertical lines for scrollbar visible in desktop add-in when add-in section is resized
When i resize the add-in section in my excel desktop app these vertical lines are visible where the previous position of scrollbar was present. It works fine for the online excel spreadsheet issue only occurs in desktop application. I have tried clearing…
Excel Add-in works on Mac & Web but not Windows
Hello, all! I've built a little Excel add-in that adds some custom functions to run calculations via a HTTP API. I developed it on my Mac using the Yeoman generator, and selected custom functions with the shared runtime. I modified the default functions,…
Can the Excel Image function accept a "data" url as the source?
Hello, I'm currently developing a Javascript add-in for Excel. During the development process, I have used both the addImage function to include images and the WebImage data type. The current interaction of the code is using the WebImage data type. The…
Trying to search for column by column value in Office Scripts
Hi everyone, I am trying to create an office script that will calculate the percentage of Y's and Y+N's in a certain column, and searching for the column name in row 4 rather than hard-coding the index. Below is my code, but I keep getting the issue…