Home » Forums » Open Source Learning Center » Question and Answer

Where are my Tools and Tabs in 2007

Submitted by Devilboy666 on 28 March, 2009 - 11:43

Yo.....

 

Just upgraded to Office 2007 kicking and screaming.....

 

Opened my workbook and all the tabs were missing...googled it says it is in 'Tools' but there are the 'Tools' and how can I get my drop down menus from 2003 back!

 

Urgh bloomin Microsoft!!!!!!

‹ AnalyzerXL? Excel Hyperlink Bug ›
»
Nick's picture

welllll...

Submitted by Nick on 28 March, 2009 - 17:52.

Excel 2007 has this thing called a Ribbon - there are no menus any more.

This thing:

 

ribbon-excel

 

Personally, I massively prefer the old menu, and I have lobbied with Microsoft for it to come back... I am assured it's there to stay..

U say the tabs are missing.. u mean the worksheet tabs ?

 

These:

worksheet-tabs

 

 

»

Yes those! And how do you

Submitted by Anonymous on 30 March, 2009 - 11:15.

Yes those!

And how do you bloomin 'save as' now ......

Agree old commands much better!!!!!

»
Nick's picture

Excel 2007

Submitted by Nick on 30 March, 2009 - 12:01.

to do the equivalent of File=>SaveAs... click the OFFICE button in the top left of your Excel..

What is the file extension you're trying to open... is it .XLS ?

 

»

What do you mean what file

Submitted by Anonymous on 31 March, 2009 - 02:22.

What do you mean what file extention am I trying to open??????

I have a worksheet 2003 edition, but my tabs are missing....

Where are they????????????

»
Nick's picture

file extension

Submitted by Nick on 31 March, 2009 - 08:53.

well... if you have accidentally change the file extension from a .xls to .txt, then u will have lost the other pages.

Can you at least see one sheet tab ? I wonder if it's something simple like the window not being maximised.. Here's the solution to that:

maximise-window

Screen shot please... !

Training Video on how to capture screen shots here:

http://excelexperts.com/Excel-Tips-Capture-Screen-Shot-of-Excel

Upload the screen shot to your original post.. Training Video here:

http://excelexperts.com/Excel-Experts-FAQ

 

Nick

 

 

 

»
Nick's picture

File Corrupt

Submitted by Nick on 31 March, 2009 - 15:37.

This was resolved over a skype conversation...

The file was corrupt, and needed to be repaired.

1 happy customer !

»