Spreadsheet Fails To Open

[Hayley Baxter]

I have a spreadsheet that will not open. There is no error message, the loading status bar at the bottom of excel just stops halfway and the excel workspace displays blank. The sheet does not show up, it's like excel starts to open it and then decides not too!

I have never seen this before and am not sure what is causing the problem. It is a very large spreadsheet which contains VBA to open / link to other spreadsheets / word documents etc.

Anyone ever seen this problem before?

Thanks
Hay

 

[Jibbadiah]

I have seen something similar recently... Try closing your database and then opening the spreadsheet.

You may have to focus on closing it in vb and then setting the excel object to nothing before opening the spreadsheet.

I have just written some code to search through my inbox, find certain attachments, save them, open them and save them as a different version. Then If I try to open the spreadsheet with the db still open I get the problem. If I close the db, the spreadsheet is fine.

HTH

James

 

[Hayley Baxter]

Thanks for the response James, Access is not in the frame here. It's a number of data files downloaded from our website. These downloads are all linked into the main spreadsheet to create a series of Graphs / Charts etc. The strange thing is there are two main spreadsheets which are basically identical other than the currency in which it is reported in, one is fine and the other one is not which confuses me even more

Thanks for taking the time to reply
Hay

 

[Jibbadiah]

Hayley,
Still sounds very similar. Are any of the linked documents open by another user?... because I think that this would cause the same problem.

J.

 

[Hayley Baxter]

No, none of the linked documents are open by anyone else, I am the only one who uses them. The end product used by everyone else is not linked at all, the links are broken when the information is updated.

Thanks
Hay