XAnalyzer
asked on
Can't click correct tabs in Excel 2007 and 2010 but fine in 2003
This is a strange issue and i'll try to explain as best possible. I have a spreadsheet called inventory.xls that I created in Excel 2003. All the users on Excel 2007 or Excel 2010 are able to view it but when they click the worksheet tabs it either does not click or clicks the adjacent tab but not the correct one ever. This is very strange. All users are on Windows-based PCs with wired keyboard and mouse and Windows XP or 7. The worksheet tabs click fine in Excel 2003 this is only in 2007 or 2010. Any ideas?
What is the size of Excel file ? Is it linked ?
Do you have macro add-ins or modules that involve the menu or the worksheet tabs ?
ASKER
The size of the Excel file is close to 10mb, what is the best way to check if it is linked to modules or has macro addi-ins in the background?
Modules can be identified by taking these steps :
- open the file
- press [Alt]-[F11]
- inside of the MS Visual Basic Editor window, you should find a "Project" overview tab with the name of the opened file in it. If not, press [Ctrl]-[R] to enable this
- unfold the underlying structures by clicking on the "+" sign (if appropriate, when already unfolded the "+" sign will turn to "-"
- if a "Modules" item is present, modules are inserted into the workbook. When no "Modules" item is found, there are no modules to be found.
- unfold the "Microsoft Excell objects" structure to investigate for macro on the worksheets present in the workbook.
- open the file
- press [Alt]-[F11]
- inside of the MS Visual Basic Editor window, you should find a "Project" overview tab with the name of the opened file in it. If not, press [Ctrl]-[R] to enable this
- unfold the underlying structures by clicking on the "+" sign (if appropriate, when already unfolded the "+" sign will turn to "-"
- if a "Modules" item is present, modules are inserted into the workbook. When no "Modules" item is found, there are no modules to be found.
- unfold the "Microsoft Excell objects" structure to investigate for macro on the worksheets present in the workbook.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
There was a hidden tab in the spreadsheet which caused the "bug" i was referring to. Thank you!