Excel files opens but worksheet(s) are not visible

jdoss999 · Mar 18th, 2002, 09:09 AM

I have a large spreadsheet that was saved last Friday. Now when I atempt to open the file, the progress bar across the bottom gets about halfway done and then stops. The filename is diplayed at the top but there are no visible worksheets. Nothing is hidden and I don't have any macros stored in this workbook. Am I hosed?

George J · Mar 18th, 2002, 09:25 AM

Ensure that you only have excel running if this is a large spreadsheet, if it still hangs does CTRL ALT DEL say that excel is not responding?

If you are low on memory, try deleting your temp. internet files to free up some space.

Good luck

jdoss999 · Mar 18th, 2002, 09:30 AM

Now I am getting the error "Cannot find file...(or one of its components). Make sure the path and filename are correct and that allrequired libraries are avialible."
Any ideas?

Chris Davison · Mar 19th, 2002, 02:24 PM

are you opening it from "start / documents" or from the recently used file list, also even from your "favourites" ?

if so, it may have been moved and it can't be found...

if you're opening via file, open and clicking then it's something more sinister, as you probably already suspected...

Jack in the UK · Mar 19th, 2002, 04:40 PM

Ermm

Any update..
Are other Xls files effected.
Email OK and word....

Can yoy enail me this file to JackinthUK@hotmail.com

I mighht have fun with this, and if has virus even more fun, love them!

Thing something sill, can see virus,,,,

Jack in the UK · Mar 19th, 2002, 04:42 PM

BTW

Though.. best scan system regardless. latest update best aswell just in case..

let me know

jdoss999 · Mar 21st, 2002, 12:52 PM

Thanks for your interest in my headaches.
I'll give you a bit more detail on the problem...
The file is size 15,707kb
I can't open the folder by any means including from within Excel or just double clicking the file icon
When I do attempt to open it, the progress meter at the bottom begins to move but about halfway through everything just dissapears and I'm left
with the grey backgorund when Excel is open but no workbooks are open.
I've tried opening the file while holding Shift key to make sure I didn't put a macro in the Workbook Open clause.
I've come to the conclusion that I have somehow corrupted the data but we don't have any Excel recovery software on site so I can't tell for sure.

I did scan for viruses and nothing else seems to be having problems.

If you have further sugggestions please let me know.
Thanks Again

Mar 18th, 2002, 09:25 AM	#2
George J Board Regular Join Date: Feb 2002 Location: Edinburgh, Bonnie Scotland Posts: 820	Ensure that you only have excel running if this is a large spreadsheet, if it still hangs does CTRL ALT DEL say that excel is not responding? If you are low on memory, try deleting your temp. internet files to free up some space. Good luck __________________ George J

Mar 19th, 2002, 02:24 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	are you opening it from "start / documents" or from the recently used file list, also even from your "favourites" ? if so, it may have been moved and it can't be found... if you're opening via file, open and clicking then it's something more sinister, as you probably already suspected... __________________ :: Pharma Z - Family drugstore ::

Mar 19th, 2002, 04:40 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Ermm Any update.. Are other Xls files effected. Email OK and word.... Can yoy enail me this file to JackinthUK@hotmail.com I mighht have fun with this, and if has virus even more fun, love them! Thing something sill, can see virus,,,, __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 19th, 2002, 04:42 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	BTW Though.. best scan system regardless. latest update best aswell just in case.. let me know __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 09:09 AM	#1
jdoss999 New Member Join Date: Mar 2002 Posts: 3	I have a large spreadsheet that was saved last Friday. Now when I atempt to open the file, the progress bar across the bottom gets about halfway done and then stops. The filename is diplayed at the top but there are no visible worksheets. Nothing is hidden and I don't have any macros stored in this workbook. Am I hosed?

Mar 18th, 2002, 09:30 AM	#3
jdoss999 New Member Join Date: Mar 2002 Posts: 3	Now I am getting the error "Cannot find file...(or one of its components). Make sure the path and filename are correct and that allrequired libraries are avialible." Any ideas?

Mar 21st, 2002, 12:52 PM	#7
jdoss999 New Member Join Date: Mar 2002 Posts: 3	Thanks for your interest in my headaches. I'll give you a bit more detail on the problem... The file is size 15,707kb I can't open the folder by any means including from within Excel or just double clicking the file icon When I do attempt to open it, the progress meter at the bottom begins to move but about halfway through everything just dissapears and I'm left with the grey backgorund when Excel is open but no workbooks are open. I've tried opening the file while holding Shift key to make sure I didn't put a macro in the Workbook Open clause. I've come to the conclusion that I have somehow corrupted the data but we don't have any Excel recovery software on site so I can't tell for sure. I did scan for viruses and nothing else seems to be having problems. If you have further sugggestions please let me know. Thanks Again