Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

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?
0
XAnalyzer
Asked:
XAnalyzer
  • 3
  • 2
1 Solution
 
techdunesCommented:
What is the size of Excel file ? Is it linked ?
0
 
Arno KosterCommented:
Do you have macro add-ins or modules that involve the menu or the worksheet tabs ?
0
 
XAnalyzerAuthor Commented:
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?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Arno KosterCommented:
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.
 



0
 
Arno KosterCommented:
For add-ins,

in the excel instance (close the VBA editor), click the round excel button and choose "excel options"
Then choose the addins option (should be the third from below) from the list and you'll notice some standard and possible some custom addins.
0
 
XAnalyzerAuthor Commented:
There was a hidden tab in the spreadsheet which caused the "bug" i was referring to. Thank you!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now