Excel Crashes on multiple saves

V

Varun

I have a macro which is like a form which gets and writes back to the
spreadsheet. The user can save the excel file from the tool itself. How ever
on multiple savings the excel sheet fails to open up saying the error "excel
has encountered a problem and needs to stop.. " .. Request you to help me in
understanding where i am going wrong?
 
D

Dave Peterson

I have no idea.

But I would put the code into a new test workbook and test the heck out of it.

If it works in that new workbook, then maybe the existing workbook is close to
being corrupted and needs to be rebuilt.

If it doesn't work, then maybe it's a problem with the code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't save my Office documents (after computer rebuild and reauthorization) 0
VBA loop to create named .csv files for all worksheets and workbooks in a folder 11
Synchronization problems while moving folders to new email 1
Excel Saves Random .xlsm File Everytime I Save 1
Macro to Consolidate Data from Various Excel Files 1
Worksheet Crashing Excel 4
Compatability Checker Question 3
Excel crashes on close 2

Top