ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with sheet tabs (https://www.excelbanter.com/excel-discussion-misc-queries/250337-problem-sheet-tabs.html)

yclhk

Problem with sheet tabs
 
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 ?

Luke M

Problem with sheet tabs
 
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"yclhk" wrote:

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 ?


yclhk

Problem with sheet tabs
 
The sheet tabs shown again, Thanks,

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

"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"yclhk" wrote:

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 ?



All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com