Colors are suddenly shot, and Excel thinks there's two workbooks inmemory.

B

Bland

I have Excel 2002 (10.2614.2625).

I have a workbook with plain data--no charts, add-ins, database stuff,
etc. Worksheet tab display is on. I have changed a couple of dozen
colors on the color palette to custom values for font & cell colors.

I don't know how this happened, but all of a sudden Excel's caption
bar at top says "MyWorkbook.xls:2", suggesting I opened a second copy
of the workbook. Which I didn't do.

Trying to quit out of "only" the ":2" or ":1" book is meaningless:
*both* contexts disappear if I do.

Symptoms:

- The ":2" book displays my custom colors but worksheet tabs are gone.
But Tools / Options / View / Worksheet Tabs restores them.

- In the ":1" context, the symptoms are the reverse: sheet tabs
display but custom colors are gone and the default palette is active.

- More seriously, if I Save As then reopen the file, it is FURTHER
corrupted. Now neither book has the custom colors.

Luckily, it appears no data is lost. And luckily my last good manual
backup is "only" two hours old.

I suppose I could reinstate the colors by manually reentering the RGB
values for my custom colors into the bad file's palette.

But I don't know how to get rid of its bogus two-workbook condition.

Is this a bug? Has anybody seen it before?

Thanks much.

***
 
G

Gord Dibben

That's just two windows of the same workbook.

Close one window then save.


Gord Dibben MS Excel MVP
 
B

Bland

Mr. Dibben:

Thanks very much for reply. As Dean Martin said in the first "Airport"
movie, Thanks, Lincoln. You just freed the slaves.

There is one complaint: my Excel 2002 has no menu option to close a
window. I had to do it graphically and indirectly, by first tiling
them then mouse-click to quit.

I'll submit that complaint in a separate thread.

Thanks again.

***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top