an old thread about sheet tabs

In article <eG5RySfsDHA.2360 RemoveThis @TK2MSFTNGP09.phx.gbl>,
"Jim Gordon MVP" <goldkey74 RemoveThis @WarmerThanwarmMail.com> wrote:

> 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.






--
Harvey Products makers of Dinghy Dogs�
The Boater's Best Friend
http://www.dinghydogs.com
Remove thefrown to email me

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>

----------
In article <info-37C532.20201223112003.DeleteThis@msnews.microsoft.com>, Harvey Waxman
<info.DeleteThis@dinghydogs.comthefrown> wrote:


>
> In article <eG5RySfsDHA.2360.DeleteThis@TK2MSFTNGP09.phx.gbl>,
> "Jim Gordon MVP" <goldkey74.DeleteThis@WarmerThanwarmMail.com> wrote:
>
>> 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.
>
>
>
>
>
>
> --
> Harvey Products makers of Dinghy Dogs�
> The Boater's Best Friend
> http://www.dinghydogs.com
> Remove thefrown to email me

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???

In article <krgraham-AF1B1D.16522301122003 RemoveThis @msnews.microsoft.com>,
"Kenneth R. Graham" <krgraham RemoveThis @mac.com> wrote:

> 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.


--
Harvey Products makers of Dinghy Dogs�
The Boater's Best Friend
http://www.dinghydogs.com
Remove thefrown to email me