Excel rewrites my hyperlinks to sharepoint
Hi, I transfered all my work files to OneDrive and encountered an issue. I use excel spreadsheets for worklist, where I use hyperlinks for pics, drawings etc for each workpiece we are currently working on. With my previous cloud service, everything was working fine. Hyperlinks used relative path, so no matter which PC I used, it all opened nicely. Now with everything being on OneDrive, excel automatically rewrote all of my hyperlinks (about 2000 of them) to sharepoint. Everything now opens with browser. Filetypes that can't be opened want to be downloaded even though I have them stored offline localy. Is there a way to stop these hyperlink changes? Excel Options > Trust Center > Trust Center Settings > External Content > "Disable automatic update of Workbook Links" is checked. When I copy the hyperlinks from the original file, they get automatically changed in the new one. When I re-link in the new file to the local file, it opens the local file and works fine. When I close Excel, open it, link is changed again to sharepoint. This is so frustrating.
Disable incessant nagware popups
I don't know about everyone else, but I am sick and tired of the nagware pop ups in Word, Excel, PowerPoint, Outlook, etc. Every single product harasses me with pop ups trying to tell me "hey, did you know this feature was here?", "you can do this if you click that", "let me hold your hand through using products you've used for decades even though you don't want daddy Microslop to do that". This is a prime example. I keep getting the same ones again and again and again and everything I've read indicates they should only appear once. But they don't. They keep coming back like a psychotic stalker ex who wants alimony even though you were never married. How do I get this nagware to stop?!
Publish an Excel Add-in by just submitting the add-in manifest to Microsoft Marketplace
I am working on Excel Add-in built using the react template. We are planning to host the add-in code on our domain and update the manifest to point to the URL for our domain. Can I just submit the add-in manifest to Microsoft to publish it in Microsoft Marketplace?Macro Dummy
I have written a Macro and it doesn't run the way it is designed and I am having problems finding my error. How would I solicit help here? I've written Excel macros for years but this one has me stumped. Probably easy for the geeks here.. I have a workbook with several tabs and then a report tab at the end. I want to identify the search criteria at in one cell and then go search in another tab in a certain row. When it finds the match it should then go down the associated column a specific number of cells and copy the contents of that cell. Then it should go back to the reports tab and paste it in a specified location. here is my macro...
Excel Power Query crashing 0xC000026F
Hi, I have the same error that was already reported by other users 0xC000026F. Since today, I have an error when I try to create a new “basic query” or if I try to refresh an existing one which was working fine last week (on January 22 it was still working fine). Error Message: Container unexpectedly exited. Exit code: 0xC000026F. PID: 19148 … From what I see my Excel is Version 2512 (build 19530.20184) from 21 January 2026… I am wondering if it is this update which crash PQ ? I have already tried: sfc /scannow then dism.exe /online /cleanup-image /restorehealth Without success… Any help would be appreciated. Regards,Web-Addins stopped working for Office apps version 16.100 for Mac
Dear experts, Since version 16.100, the web add-in functionality has stopped working with the Office apps for Mac (PowerPoint, Word and Excel). In may case, Templafy web add-in is not being loaded. According to Templafy's support page: https://support.templafy.com/hc/en-us/articles/29028257609501-Templafy-Web-Add-ins-no-longer-accessible-on-Mac-after-Microsoft-Office-update-16-99 this seems to be a bigger issue. Clearing web add-in cache or deleting the WEF folder will not resolve the issue. I have also tried with a full clean uninstallation of Office365 apps and re-installation, same issue. Note that New Outlook for Mac is not affected, just PowerPoint, Excel and Word.Why is Excel macros sometimes missing ?
I have an excel file with a lot of rectangular shapes showing a tree structure for a family. When the user clicks on one of the rectangulat shapes the 'story' of that person opens up in a Word dokument. BUT ... Most often the macro 'assigned' to the OnAction WONT run - instead this message comes up: The macros is NOT shown when I "show macros" but it IS present in the VBA section when I press alt+F11 ! When it's working it's most often reight after a reboot og the machine - then it maybe works in 10-30 minuts and then the problem is back again ! I HAVE chesked the security setting allowing macros to be activated ! I have tha SAME file running under Window 10 for years WITHOUT any problems !!!! I can see out there that people FOR YEARS have had similar problems with missing macros - but unfortunately I found no solution ! What the _BEEP_ is wrong here ?
Import data from a Microsoft Forms PDF into Excel
Hi all. I have a number of PDFs for clients which contain questionnaires, score sheets, etc. Some are completely external, and some are from Microsoft Forms. A while back, I created a Macro/some VBA code to read data from the external PDFs, import it into Excel and display the figures; it works really well. Today, I've tried to update it to load data from the PDFs created by "printing" a Microsoft Forms complete questionnaire and saving as a PDF - unfortunately, when trying to import this into Excel (using "Get Data -> From File -> PDF"), the "Likert" questions are appearing but showing "null" for all the columns, not identifying which contains the "selected" checkbox. Possibly a slim hope, but I was wondering if anyone has experience doing something similar, or can recommend a way to get this to work? I know there are potentially other ways to approach this (I tried connecting it directly to the linked Sharepoint Excel file, but the URL is entirely powered by URL arguments ?foo=bar&baz=boing etc, and Excel demands those all be deleted when giving it a filename to connect to to get data from the web, helpfully); connecting it to a "local" version of the Excel file on OneDrive is a possibility, but ideally I'd a) want the tool to be accessible to people who have access to the PDFs but not the spreadsheet, and b) have to save the print-out PDFs in every client folder to store their data together, and the spreadsheet may occasionally be purged, so the PDF is the "safe" way to access the data.) PDFs can't be run through any online tools due to containing sensitive data. Many thanks.External people can't open files with Sensitivity Label encryption.
Question: What are the best practices for ensuring external users can open files encrypted with Sensitivity Labels? Hi all. I've been investigating proper setup of sensitivity labels in Purview, and the impact on user experience. The prerequisites are simple enough, creating and configuring the labels reasonably straightforward, and publishing them is a breeze. But using them appears to be a different matter! Everything is fine for labels that don't apply encryption (control access) or when used internally. However, the problems come when labels do apply encryption and information is sent externally. The result is that we apply a label to a document, attach that document to an email, and send it externally - and the recipient says they can't open it and they get an error that their email address is not in our directory. This is because due to the encryption, the external user needs to authenticate back to our tenant, and if they're not in our tenant they obviously can't do this so the files won't open. So, back to the question above. What's the easiest / most secure / best way to add any user we might share encrypted content with to our tenant. As I see it we have the following options: Users have to request Admins add the user as a Guest in our tenant before they send the content. Let's face it, they'll not do this and/or get frustrated. Users share encrypted content directly from SharePoint / OneDrive, rather than attaching it to emails (as that would automatically add the external person as a Guest in the tenant). This will be fine in some circumstances, but won't always be appropriate (when you want to send them a point-in-time version of a doc). With good SharePoint setup, site Owners would also have to approve the share before it gets sent which could delay things. Admins add all possible domains that encrypted content might be shared with to Entra B2B Direct Connect (so the external recipient doesn't have to be our tenant). This may not be practical as you often don't know who you'll need to share with and we work with hundreds of organisations. The bigger gotcha is that the external organisation would also have to configure Entra B2B Direct Connect. Admins default Entra B2B Direct Connect to 'Allow All'. This opens up a significant attack surface and also still requires any external organisation to configure Entra B2B Direct Connect as well. I really want to make this work, but it need to be as simple as possible for the end users sharing sensitive or confidential content. And all of the above options seem to have significant down-sides. I'm really hoping someone who uses Sensitivity Labels on a day-to-day basis can provide some help or advice to share their experiences. Thanks, Oz.
