Tabs go missing when worksheet created on 365 is opened in 2007

andymalan

Board Regular
Joined
Feb 22, 2017
Messages
128
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
I have a worksheet that was constructed on Excel 365 and has 5 or 6 tabs. when I run this worksheet on a computer that has excel 2007 all the tabs are hidden, as well as the scroll bars. I have checked the display options for the 2007 worksheet and all the boxes are checked.
if I open a brand new 2007 worksheet, the tabs are visible.


Anyone that can help?
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
I have a worksheet that was constructed on Excel 365 and has 5 or 6 tabs. when I run this worksheet on a computer that has excel 2007 all the tabs are hidden, as well as the scroll bars. I have checked the display options for the 2007 worksheet and all the boxes are checked.
if I open a brand new 2007 worksheet, the tabs are visible.


Anyone that can help?
So I have (by accident) found that you can open a new window, and PRESTO, all is visible
☺☺
 
Upvote 0
Solution

Forum statistics

Threads
1,215,343
Messages
6,124,394
Members
449,155
Latest member
ravioli44

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top