|
|
|
|
 |
September 22nd, 2004, 11:49 PM
|
 |
Brigadier General
|
|
Join Date: Apr 2002
Location: Kailua, Hawaii
Posts: 1,860
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Re: OT: Can anyone help me with this Excel problem
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.
__________________
Slick.
|
September 23rd, 2004, 01:21 AM
|
 |
Major
|
|
Join Date: Aug 2000
Posts: 1,246
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: OT: Can anyone help me with this Excel problem
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
__________________
When a cat is dropped, it always lands on its feet, and when toast is dropped, it always lands with the buttered side facing down. I propose to strap buttered toast to the back of a cat. The two will hover, spinning inches above the ground. With a giant buttered cat array, a high-speed monorail could easily link New York with Chicago.
|
September 23rd, 2004, 01:27 AM
|
 |
Shrapnel Fanatic
|
|
Join Date: Jul 2001
Location: Southern CA, USA
Posts: 18,394
Thanks: 0
Thanked 12 Times in 10 Posts
|
|
Re: OT: Can anyone help me with this Excel problem
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. |
September 23rd, 2004, 01:53 AM
|
 |
Lieutenant General
|
|
Join Date: Nov 2002
Posts: 2,903
Thanks: 1
Thanked 0 Times in 0 Posts
|
|
Re: OT: Can anyone help me with this Excel problem
I don't know if this will help, but how about temporarily setting the virtual memory really high to try to open that file?
|
September 23rd, 2004, 01:59 AM
|
 |
Lieutenant Colonel
|
|
Join Date: Mar 2001
Location: Emeryville, CA
Posts: 1,412
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: OT: Can anyone help me with this Excel problem
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).
__________________
GEEK CODE V.3.12: GCS/E d-- s: a-- C++ US+ P+ L++ E--- W+++ N+ !o? K- w-- !O M++ V? PS+ PE Y+ PGP t- 5++ X R !tv-- b+++ DI++ D+ G+ e+++ h !r*-- y?
SE4 CODE: A-- Se+++* GdY $?/++ Fr! C++* Css Sf Ai Au- M+ MpN S Ss- RV Pw- Fq-- Nd Rp+ G- Mm++ Bb@ Tcp- L+
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|
Hybrid Mode