Serious Need of HELP!!!

[Gene Wilbourn]

Getting a "Not Enough Memory" error when I attempt to open
a spreadsheet with only "OK" as an option to clear the
dialog box. I have a lot of data in this speadsheet. It is
only data in fields, no calculations, no charts/graphics
and it is only <3 mb in size. It resides on a network
drive so various users can view it but only one user
has 'write' rights. It isn't open by another user. We get
the error on any PC we try to open it on.

Previous posts did not provide any response but I am in
need of help here and would appricate any assistance I can
get to get the data back. Excel did not give a warning
about not being able to get your data at a certain point.

I hope someone can help me....Thanks!!!!

 

[Jan Karel Pieterse]

Hi,

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set
macro security to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button,
press control-pageup or control-pagedown, thus changing
sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the
worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you
for a sheet name.

Sometimes the Excel viewer, Word or even Internet explorer
(v5) enables you to open the file and copy information out
of it.

If the file is not protected, maybe you can open it with
OpenOffice (www.Openoffice.org).

Also, Excel XP can sometimes repair XL files with trouble.


Regards,

Jan Karel Pieterse
Excel TA/MVP