Saving Issue

[Version]

Currently using a workbook that has multiple tabs, macros, formulas, etc. Takes quite a bit of time to fill in all the information and when trying to save, the excel file brings up an error message stating that their was an issue when saving the workbook.

"Errors were detected while saving. Excel may be able to save the file by removing or repairing some features." When clicking ok, nope.. nothing.

Any ideas? Could it be from macros?

 

[Logit]

.
This is what I would do (not necessarily what others might do ... we all have our own ways of trouble shooting):

In the VBE, under TOOLS / Clean Project .... Under DEBUG / Compile VBAProject.

If that doesn't correct things .. do you have the phrase OPTION EXPLICIT at the top of all of your modules in the VBE ?
OPTION EXPLICIT is an automated code checker that helps you insure your coding is correct. It provides suggestions
when it finds an error. Although your present code may not be generating errors (especially if you have error traps set),
there may still be some problems you are not aware of.

Speaking of error traps, comment out all of your ERROR HANDLERS. Then run your project and see if there are errors.

For me, as a last resort, I would use this freebie : https://excelfilecleaner.codeplex.com/
It has repaired several (not all) workbooks for me when they simply wouldn't run otherwise. When it can repair things,
it does a really good job in my experience.

AS ALWAYS .. DO ALL OF THE ABOVE ON A COPY OF YOUR WORKBOOK - NOT THE ORIGINAL. That way if something goes
wrong you haven't lost the original code.