an old thread about sheet tabs

[Harvey Waxman]

There was a thread some time back about the sheet tab labels being invisible.
I'm certain that it is related some file corruption. I wonder if there is a
place to discuss this issue with a bug doctor.

I have much more information about the idiosyncrasies related to the file
corruption and would appreciate discussing it with someone.

thanks

Harvey

Excel Office X

 

[Jim Gordon MVP]

Hi Harvey,

This is the right place to have the discussion. The doctor is the entire
user group community.

Someone showed a workbook to me this week that had the problem. Simply
switching between workbooks and opening and closing Excel corrected it for
my co-worker.

I do know the problem happens infrequently. The topic rarely comes up in the
newsgroups as you probably noticed.

In order to correct the problem Microsoft will need an exact step-by-step
scenario that causes the problem to occur. Because it involves display, it
could be related to a specific hardware configuration.

We need to play detective. For starters, do the problem tabs appear the same
way on all macs or just on one computer in particular? Is it just one
workbook or is this happening on several workbooks?

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Harvey Waxman]

We need to play detective. For starters, do the problem tabs appear the same
way on all macs or just on one computer in particular? Is it just one
workbook or is this happening on several workbooks?

I foolishy neglected to test the file on another computer. The other one uses
8.6 and I am using 10.2.6 but I should have done it anyway.

I have had the issue only with one workbook at a time and is has always been a
huge one, 13+ megabytes.

As I noted on this forum before, if Excel is opened first and the file is the
opened from within Excel, it will be fine as will subsequent files that are
opened.

I now noticed that if the file is double clicked to start Excel the blank sheet
tabs (not really blank, just white text) will appear as with all subsequent
files opened. When Excel is quit and restarted, it's back to normal as long as
the suspect file is not double clicked first.

Another finding is that the file grew rather large. It started as 13 meg and
after is was saved as a sylk file I noticed it was 29 meg.

I finally corrected it by getting rid of all formulas and named cells. I
created a new file, copied only the values to it one column at a time (50,000
rows) and then recreated and copied the formulas down.

This fixed the file - so far.

It is still very slow, 20 minutes to calculate seems way too slow. As I said
there are 50,000 rows by 20 columns. Formulas in five columns are fairly
complex but it is still pretty bad as for speed.


OSX.2.6 with 1gig ram and 1gHz chip.

 

[Jim Gordon MVP]

Hi again,

OK - that's good. Your copy is fixed and working OK. If you do something and
it causes the problem to re-occur and you can describe the exact steps then
that would be something we can send in to Microsoft and have them reproduce
the steps.

If you want to submit the slow calculating workbook to Microsoft for
Analysis send an email to me privately and we can work out a way to get it
to them.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------

 

[Kenneth R. Graham]

Just encountered the same problem, and the same work-around.

If I double-click an .xls file with multiple sheets, the sheet labels
are BLANK. Double-clicking on the label itself will show the label text,
but as soon as it's unselected, it goes blank again. This is a
repeatable situation!

However, if I open Excel and then open the .xls file, the sheet labels
appear and work as expected!

Interesting???

 

[Harvey Waxman]

Just encountered the same problem, and the same work-around.

If I double-click an .xls file with multiple sheets, the sheet labels
are BLANK. Double-clicking on the label itself will show the label text,
but as soon as it's unselected, it goes blank again. This is a
repeatable situation!

However, if I open Excel and then open the .xls file, the sheet labels
appear and work as expected!

Interesting???

That file is corrupt and you'd best copy the data to a new file. I'd even
suggest redoing the formulas.