One specific file gives errors

[DutchKevin]

Hi, we have nice tracking file in excel at work.
However that is also the one file that gives various errors. It does so on all computers, both when file is on network, and also if we try it with a local copy on Cdrive.
When opening the file it warns that "excel cannot complete the task with available resources".
It also has been known to reply with "document not saved" when saving. This occurs quite random. Happens often but not always.
And last but not least the File button doesn't visualy respond to mouse click anymore. Via the key shortcuts we can still perform "Save" and so on, if we know the applicable shortcuts.

The file itself is built up of one overview sheet and over 200 sheets. all sheets connect to the overview sheet.
It has also VBA code for buttons and filters, and code on fileopen and fiel close. the VBA code does not look to extensive to me. Ranges are not too big, operations not too complex.

What I want to ask you is if you can advise me where (or how to try) to repair this. Or is someone willling to have a look with me to this file?

thanks
kevin

 

[VoG]

This may help you https://support.office.com/en-gb/ar...4ab-b7d1-0f81c22f39a2&ui=en-US&rs=en-GB&ad=GB

 

[DutchKevin]

Hi Peter,
Thanks for looking at this post.
I have tried the open and repair option earlier. it did not help. The file itself does not report explicitely a corrupted status either.
Also i have once tried to copy certain sheets to a new workbook, but the save function doesn't work for the old or new file. It asks to save or not, but when clicking yes, it will not present a dialog to add name or slecte folder.

 

[VoG]

Then maybe try http://www.mrexcel.com/forum/excel-questions/223851-rebuild-your-workbook.html

 

[WaterGypsy]

Save doesn't usually ask for a new name/destination .... have you tried SaveAs ?

 

[DutchKevin]

I was hoping to avoid rebuild. 200+ sheets of data... hmmm
And both save and save-as behave equal in that respect.
Is there perhaps a limit to the amount of calls to a specific VBA code that may exist in a workbook? all data sheets have the same "Back to Mastersheet" button.

 

[DutchKevin]

Hi, just wanted to let you know that it is finally solved.
The file nearly crashed permanently while trying to recover but the deal was this.

Each of the 200+ sheets had two sum fields that totalled from row 8 to row to the bottom of sheet 1048576. so a lot of sum's with very little in it. Used to work fine in Excel 2003 and 7 where the amount of rows was a lot smaller.
So I reduced the sum ranges of all sheets and now it works fine agian.

Happy easter to you all !