Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Give Feedback

Drilldown button in incorrect cell


Symptom:

The Drilldown button is not located in the correct cell

 

Cause:

This is an issue with Excel when you use the Zoom feature and the Zoom Percentage in not a multiple of 5.

Resolution:

Set the Zoom Percentage to a multiple of 5.

You may not be able to use the Excel Zoom slider to accomplish this.  When using the slider, it is possible to select a value that may be reported by Excel as 75%, but is actually slightly different (for example 75.3%).  To set the Zoom Percentage exactly, you will need to use View, Zoom from the Excel Ribbon.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments