Link to home
Start Free TrialLog in
Avatar of XAnalyzer
XAnalyzerFlag for United States of America

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?
Avatar of techdunes
techdunes
Flag of United Arab Emirates image

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 ?
Avatar of XAnalyzer

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.
 



ASKER CERTIFIED SOLUTION
Avatar of Arno Koster
Arno Koster
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
There was a hidden tab in the spreadsheet which caused the "bug" i was referring to. Thank you!