Forum Discussion
Save Failed: There was an internal error..
I don't know why my original post was taken down, I was directed to post here by microsoft staff.
Hello,
I developed a python script in an IDE and it always worked. I ported it to python in excel and it works. However, I frequently get this error. Often it is after I save a change that has some syntax problem. Despite removing the lines that caused the syntax error, suddenly any change doesn't work.
I could remove all of my code and write print('hello world') and I will get the save failed error.
I have tried:
- Pasting in old code from older, valid versions
- Removing all code and putting print('hello world')
- Updating Excel
- Repairing Excel
- Reinstalling Excel
- Restarting my computer
- Updating my computer
- Putting code in a new cell
- Putting code in a new work sheet
- Putting code into new workbook (this works but not forever, if the error happens again, I have to create a new workbook and that is incredibly inconvenient
Link to offending workbook:
https://1drv.ms/x/c/05ca45c91ad09cb7/EeQGntvd3sVFmieT7DBidP8B1z9Ga9d_BQg_cZ2VryoRqg?e=7IuKrw
1 Reply
Worth trying this:
- Clear Python output cache: Try deleting all Python output cells and then saving. Sometimes the output itself causes issues.
- Save as .xlsx (non-Python): Save the workbook as a regular .xlsx file (without Python), then re-enable Python and reinsert your code.
- Use Excel Online: If available, try opening the workbook in Excel for the web and see if the issue persists there.
- Check for hidden named ranges or links: Sometimes Excel stores hidden references that can cause save errors. Use the Name Manager to inspect and delete any suspicious entries.
