Problem with sheet tabs

Y

yclhk

My MS Office is Office 2003.

While open a new workbook in Excel, the sheet tabs are not shown, I need to
set by tools -> option and check the sheet tab every time. How to set the
workbook opened with the sheet tabs ?

Also, there is a extra menu tab "addin" shown at the top menu of workbook,
i.e. File, Edit, View, Insert, ...., addin, Help. While addin is clicked, a
message of "solution.xls not found" shown. How to fix it ?
 
L

Luke M

The first problem:
Open a blank workbook, go to Tools - Option and change the settings. Now,
close the workbook. Your changes should now be saved as the default settings
for a new workbook.

The second problem:
Under Tools-Add ins. Check to see what all is activated. It sounds like a
custom add-in was activated, but the workbook has been lost/deleted. Remove
the add-in from the list to stop XL trying to load the add-in.
 
Y

yclhk

The sheet tabs shown again, Thanks,

I cannot find any extra add-in in the list and all the add-ins are not
activated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top