sometimes cannot perform SAVE in Excel

[bromberg]

Occasionally, for some reason, much to my surprise,I am unable to SAVE my changes to my Excel workbook.
Is there a way I can uncover the offending cell that is preventing the SAVE?
I typically use this workbook as my "bookmark warehouse" to store URLs and my comments in cells and excel-comments, and perform no calculations or pivot tables, etc..
Although Excel offers to do a check, it never gives any advice of what went wrong when it's done checking so I am forced to not save my work and start over...grrr!

Thanks in advance to all who reply.
Dan

 

[oldbrewer]

take a copy of it, delete half of it, save 50 times, if all saves ok, start over, delete the other half and save 50 times - if save fails, start over, split in half repeat, repeat repeat

 

[bromberg]

take a copy of it, delete half of it, save 50 times, if all saves ok, start over, delete the other half and save 50 times - if save fails, start over, split in half repeat, repeat repeat

Thanks for your suggestion, but with all the options in Excel, you'd think they'd be able to spit out an error message pointing to the problem (or better yet, complain on the faulty entry as soon as I made it).
Thanks again,
Dan

 

[oldbrewer]

nobody is perfect..........

 

[Fluff]

nobody is perfect..........

Least of all Microsoft
@bromberg
Do you have any event code (macros) in that workbook?

 

[bromberg]

Least of all Microsoft
@bromberg
Do you have any event code (macros) in that workbook?

FYI, no macros in the workbook.
Dan

 

[bromberg]

Not expecting perfection but it seems to me with all the features Excel has to offer, debugging (or better yet, preventing) a problem should be at the top of their list.
When I used to code I would always check for a zero divisor before performing division.
Dan

 

[oldbrewer]

make a copy keep deleting 5% and trying to save

 

[bromberg]

make a copy keep deleting 5% and trying to save

Thanks, but that's too time consuming and would probably be easier to just recreate my entries (since they're usually all on my clipboard).
I'll just carry on with my MS 'love/hate' relationship.