OT: Can anyone help me with this Excel problem??!!

geoschmo · #1 September 22nd, 2004, 07:13 PM

You might also try creating a new excel workbook, and then on the data tab click Import external data|Import data. Browse to your excel file you are having trouble with. It should then give you a list of the worksheets in that workbook without actually opening the entire workbook. It might still give you memory problems, but it might work. If it does you can save each worksheet as a separate workbook then.

Slick · #2 September 22nd, 2004, 11:49 PM

I came across a similar problem a couple of years (and maybe Versions) ago and I ended up checking the microsoft website. I found that for my particular problem, there was a known bug that would prevent me from ever opening my file again and there was not a good fix. There was a band-aid solution that would transfer data but not all the charts, etc.:

This is similar to what geo mentions above.

Create a new workbook file. In cell A1 link it to cell A1 in the other file. Then copy this to all cells in all sheets. This will link each cell in the new workbook with its corresponding cell in the broken file without ever needing to open the file as a whole. Next, copy all cells and, using "paste special", paste "values" or "formulas" as you see fit. This will convert the links to real values/formulas. You will probably have to do this on a sheet by sheet basis.

You will lose charts and a lot of other things this way but you will be able to at least save data.

Hope this might help.

Slick.

Instar · #3 September 23rd, 2004, 01:21 AM

www.newegg.com
buy more memory
(heh, just kidding)
Geo got it right

oh, I wouldnt use Open Office myself, the Last time I used open source it left a really really really bad impression

Fyron · #4 September 23rd, 2004, 01:27 AM

Quote:

Instar said:
oh, I wouldnt use Open Office myself, the Last time I used open source it left a really really really bad impression

That is like saying, "I played Civ 3, and it sucked, so that left a really, really, really bad impression on computer games..." Like closed source software, some open source software is good, some is bad.

Kamog · #5 September 23rd, 2004, 01:53 AM

I don't know if this will help, but how about temporarily setting the virtual memory really high to try to open that file?

Will · #6 September 23rd, 2004, 01:59 AM

Hmmm... I'm using Open Office exclusively now, with no real problems (other than I couldn't figure out how to vertical align a page the other day without turning the whole thing into a one-cell table and v-aligning that).

Then again, the reason I'm using it exclusively is I don't have access to a MSOffice disk, and I don't feel like shelling out the cash for it.

The export to PDF option was essential for me (until I got my hands on a semi-legit copy of Acrobat Pro, bought somewhere in Asia).

AMF · #7 September 23rd, 2004, 10:42 AM

Hmmm...I don't seem to have a "import data" option, but instead a "microsoft query" option that allows me to import data from other databases - including Excel. Unfortunately, I am ignorant of microsoft query. Why is it that in every other MS app there is an "import data" option, but not in excel. nevermind, I know the answer and his name starts with Bill.

Still working on it...
thanks!
Alarik

Quote:

geoschmo said:
You might also try creating a new excel workbook, and then on the data tab click Import external data|Import data. Browse to your excel file you are having trouble with. It should then give you a list of the worksheets in that workbook without actually opening the entire workbook. It might still give you memory problems, but it might work. If it does you can save each worksheet as a separate workbook then.

geoschmo · #8 September 23rd, 2004, 10:46 AM

I'm using excel and have an import external data option. It might be one of those options you have to install when you setup excel. This is a work computer that someone else set up for me so I can't say what options were selected at the time.

AMF · #9 September 23rd, 2004, 11:59 AM

Hmmm..what Version of Excel do you have?
Thanks!
Alarik

Quote:

geoschmo said:
I'm using excel and have an import external data option. It might be one of those options you have to install when you setup excel. This is a work computer that someone else set up for me so I can't say what options were selected at the time.

DarkHorse · #10 September 23rd, 2004, 07:49 PM

The only problem with the Import External Data option is that it doesn't import your calculations and formulas, only the results. At least it didn't when I just tried it. Also it didn't copy the formatting either.

Edit:
There is a Detect and Repair option under the help menu (at least in my Version) perhaps if the file got corrupted this could help.