•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Personal account Automate not working
Our take
Hello everyone,
I’m reaching out for help regarding an issue with my Office Scripts stored in OneDrive. A few months ago, I successfully created and ran .osts scripts in Excel, but recently I’ve encountered a problem. While trying to access my scripts, I received a “Bad Request” error, and most of my scripts seem to be missing. Despite restarting my PC and clearing temporary files, the problem persists. Has anyone experienced a similar issue or found a solution? I appreciate any insights you can provide.
Hello all,
Several months ago I typed some .osts scripts to run against data in Excel. They worked fine and ran. They are stored in my OneDrive Documents/Office Scripts folder and always have been. It is a personal 365 account, so I realize the feature is in Preview.
Recently I opened Excel and it could not find most of my scripts. When I click the folder button on the one I can see that used to take me to the folder where they were stored, a window pops up that says Bad Request with a url containing cdnstorage.public.onecdn.static.microsoft. I can make a new script from excel but it does not appear in the onedrive folder when I do that now.
I restarted my PC, logged in and out of One Drive, used PC manager to clean all my temp files, I am at a loss.
Has anyone experienced this before?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Lost a whole day's work despite Autosave and OneDrive/SharepointI'm at a loss for words. I'm working on a thesis I'm using an excel sheet in a shared onedrive/sharepoint folder with my supervisor, though I'm working on the excel sheet in the app with autosave on and everything, rather than directly in the browser. This morning, as I began working on the excel sheet, the window crashed, and when it restarted again I just clicked away the massive window with recovery files (because this has happened many times, and it's never reverted any data before, I'm working via the cloud, and the window is massive and annoying). Only then did I realize the version I had up was missing an entire full-day's work. I went into the onedrive/sharepoint in my web browser and went into the change history, and that too was missing the whole of yesterday. I went into %appdata% but could find no recovery file, probably because I dismissed them. How did this happen, and is there any way to recover the lost data, like some recycle bin for the recovery file or something? I was logged in to the correct user and everything with no error messages yesterday, green checkmark on autosave etc. submitted by /u/Baba_Wethu [link] [comments]
- Excel .xlsm files showing “We found a problem with some content” after savingHi everyone, Good day. I’m currently experiencing an issue with Microsoft Excel involving macro-enabled files (.xlsm) that contain VBA code and are stored in Microsoft OneDrive. Scenario: I open an .xlsm file (with VBA), make edits or even just open and save it. When I reopen the same file, I get the error:“We found a problem with some content… Do you want us to try to recover as much as we can?” Additional details: Files created in 2025 were working before, but now they are no longer working even if I did not make any changes. The issue now happens consistently even without modifying the file. What I’ve tried: Opening and repairing the file Saving as a new file Checking OneDrive sync Has anyone encountered this issue recently, especially with OneDrive syncing and .xlsm files? Any suggestions or fixes would be greatly appreciated. Thank you in advance for your help. https://preview.redd.it/wycqd6215fzg1.jpg?width=362&format=pjpg&auto=webp&s=a695ef001723887a5f9739c96e92bc21f0b5ab1e submitted by /u/Electronic-Tear-4567 [link] [comments]
- How do you properly hand over Office Scripts or trigger Power Automate flows from Excel without relying on personal OneDrive?Hi everyone, I’m running into a problem and I hope someone here has experience with this. I was asked by another department to automate one of their workflows in Excel. So far so good. I didn’t want to use VBA because our company is slowly phasing it out, so I took this as an opportunity to gain experience with Office Scripts. The script itself is finished. It can be triggered via a button and it works as intended. However, I realized that I don’t want the script to live in my personal OneDrive “Documents/Office Scripts” folder. I want to hand it over to the department so they can use it independently. My idea was to create a subfolder called “Scripts” next to the Excel file and store the scripts there. But here’s the problem: I have no idea how to reference or trigger those scripts from Excel. Excel seems to only recognize scripts stored in the personal Documents folder. Even if I manually place the script there (tested with a separate account), Excel still doesn’t detect it. So I thought about triggering the script through Power Automate instead. Surprisingly, that works well — and PA doesn’t care where the script file is stored. BUT now I have a new issue: How do I link the flow back to the Excel file? Ideally, I want a button inside Excel that starts the flow. The users of this file are not technical at all, so it needs to be as simple as possible. I couldn’t find any way to connect a button in Excel to a Power Automate flow — except by using Office Scripts again, which would put me back in the same situation where the script must be stored in my personal OneDrive… which defeats the whole purpose. Has anyone dealt with this before? How do you hand over Office Scripts or trigger flows in a clean, future‑proof way so everything keeps working even if you’re no longer around? Thanks a lot for your help! PS. This text was translated and optimized with AI submitted by /u/MR_Datenanalyse [link] [comments]
- Excel file recovery optionsThe company I work for uses microsoft teams and one-drive to manage all of their files and file sharing systems. I have a file on my desktop on my work laptop that I go into, edit, and save essentially every day. I had this file open this morning after making edits last night. I made a few more edits, saved it and then closed out. When I went to open the file this evening I was met with a message below the toolbar that said “latest uploaded failed” with the options of "save a copy" or "discard changes". At this point the edits I made this morning were still visible in the file so I thought the message just related to the edits from this morning when I was moving filters around, since I had the file open last night and saved it at that point. I clicked "discard changes", the file closed out and when I reopened the file it had restored a version from February. How do I find the copy of this file from last night or is it completely gone? I would think that since I opened and saved this file 100+ times since the February that there would be a more recent version? Especially given this is the first time I ever got this error message. Thanks in advance for any help submitted by /u/username_738395958 [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Office Scripts#Excel#script#OneDrive#.osts scripts