Excel 2007 not showing tabs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale - 27 Sep 2007 23:00 GMT

I have just installed Office 2007 and when I went to open one of my older
spreadsheets none of the page tabs are showing. When I open the spreadsheet
on another machine the tabs are still there.
How do I get page 2, 3 and so on to appear as tabs at the bottom?

Any suggestions are greatly appreciated

Thanks
Dale

Reply to this Message

Wondering - 27 Sep 2007 23:41 GMT

Office Button/Excel Options/Advanced/Display options for this workbook -
Check Show sheet tabs

>I have just installed Office 2007 and when I went to open one of my older
> spreadsheets none of the page tabs are showing. When I open the
[quoted text clipped - 6 lines]
> Thanks
> Dale

Reply to this Message

Dale - 28 Sep 2007 00:02 GMT

I went there and that option was already checked, I unchecked it, closed and
reopened then rechecked it and still no tabs. Again I can go to another
machine that has 2007 on it and the tabs display there. Any other thoughts?

> Office Button/Excel Options/Advanced/Display options for this workbook -
> Check Show sheet tabs
[quoted text clipped - 9 lines]
> > Thanks
> > Dale

Reply to this Message

Wondering - 28 Sep 2007 00:46 GMT

Another possiblity is that your scroll bar at the bottom of the worksheet
which is on the same line as the tabs is extended all the way to the left,
completely hiding the tabs and the tab controls. If the left-pointing arrow
on the scroll bar is at the extreme left, click just to the left of the
arrow and drag the bar to the right and make it smaller to unhide the tab
controls and the tabs. Do the tabs show in other workbooks?

>I went there and that option was already checked, I unchecked it, closed
>and
[quoted text clipped - 16 lines]
>> > Thanks
>> > Dale

Reply to this Message

Dale - 28 Sep 2007 13:17 GMT

No scroll bar appears on the worksheet I'm having problems with, that same
worksheet can be put on another workstation and it appears normally. On the
workstation that is having this issue I can open a few other spreadsheets
normally and a few of the other spreadsheets are having the same issue

> Another possiblity is that your scroll bar at the bottom of the worksheet
> which is on the same line as the tabs is extended all the way to the left,
[quoted text clipped - 23 lines]
> >> > Thanks
> >> > Dale

Reply to this Message

Wondering - 28 Sep 2007 15:54 GMT

You're saying some of the workbooks have tabs and scroll bars and some don't
on this particular workstation and yet all of the same workbooks have tabs
and scrollbars on the other workstations?

> No scroll bar appears on the worksheet I'm having problems with, that same
> worksheet can be put on another workstation and it appears normally. On
> the
> workstation that is having this issue I can open a few other spreadsheets
> normally and a few of the other spreadsheets are having the same issue

Reply to this Message

Dale - 30 Sep 2007 16:01 GMT

Yes that is correct, wish I could post screen shots in here.
The workstation in question will display this one worksheet with no scroll
bar and no tabs even though the options are checked in the worksheet to have
those displayed. I can put that worksheet on a thumbdrive go to another
workstation with 2007 installed, open it and the tabs and scrol bars are
there. At the workstaion in question I can open other worksheets and they
appear normally.
Is there a way to import the data from this worksheet to another excel
worksheet to see if when re creating the data it will then create the tabs?

Thanks
Dale

> You're saying some of the workbooks have tabs and scroll bars and some don't
> on this particular workstation and yet all of the same workbooks have tabs
[quoted text clipped - 5 lines]
> > workstation that is having this issue I can open a few other spreadsheets
> > normally and a few of the other spreadsheets are having the same issue

Reply to this Message