dead spreadsheet help

[MartinL]

Hi

I have a huge spreadsheet that I have been working on for a couple of months now, with lots of input for you guys, that has crashed on me this morning.

Now usually when this happens I reboot th PC and it resolves itsself, but this time Excel says the data is corrupt and cannot open it.

Does anyone know of a way of repairing the sheet. Excel tries but fails.
I do have a back up that is 2 days old so its not a major disatster but it would be nice to retrieve yesturdays work if possible.

Martin

 

[MartinL]

Hi guys

Just a note about this. I recreated the file from my backup and saved along with an excel generated backup .xlk

I tried to open it again this morning and I get the same error (unreadable content, blah, blah, blah...)

The sheet is 40Mb, yep its huge, with 2 pivot tables but thats what happens when your company will not sanction the use of Access.

Could the sheer size of the workbook be causing the issue?

Martin

 

[Richard Schollar]

I have used workbooks much bigger than 40Mb (never a particularly happy experience, especially if there are many formulas within).

It could be that your workbook is corrupt in some way though so you may well be best advised to recreate it (and this means from the ground up eg with a fresh new workbook and then copy across any formulas etc and recreate the data connections to Access and the pivot tables). You may find the resulting new workbook is more stable.

 

[MartinL]

Hi Richard

Thanks for your input, I will hve to try that then.

NB I wanted to use access, but IT wll not allow it, you have no idea the arguments it has caused, they even tried a disaplinary after I brought in one of those freebie Databases.
So much history.....


Martin