locked
Horizontal Scroll Bar in Power Pivot? RRS feed

  • Question

  • Good Afternoon,

    I have recently installed PowerPivot and began importing my T-SQL queries into it, unfortunately for queries with a large number of columns, I am unable to see a horizontal scroll bar, although I do have a vertical scrollbar.  I can move my cursor to the right, however it just disappears off screen.  Is there any way to add a horizontal scrollbar to the PowerPivot window?

    Monday, November 10, 2014 11:15 PM

Answers

  • Thanks for providing the screen shot. This behaviour isn't normal; the horizontal scroll bar should definitely by present in this scenario.

    • Does re-sizing the Power Pivot Window cause the horizontal scroll bar to appear?
    • Does toggling between the Data View and Diagram View make a difference?
    • Does disabling and then re-enabling the Power Pivot Add-in make any difference?
    • Does the same thing happen if you create a new workbook and load the same table?
    • Have you already tried a repair on your Office installation?

    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com
    Blog: http://www.nimblelearn.com/blog
    Twitter: @nimblelearn

    Thursday, November 13, 2014 12:28 PM

All replies

  • Hi LinuxBrandon,

    Could you kindly provide a screenshot of this problem so that other members of the forum or myself can help?


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com
    Blog: http://www.nimblelearn.com/blog
    Twitter: @nimblelearn

    Tuesday, November 11, 2014 9:30 PM
  • Hi Michael,

    I will post an image as soon as I am able to get my account verified.  If you go to the PowerPivot 'Manage' screen, there is a vertical scrollbar on the far right hand side of the screen, but no horizontal scrollbar anywhere.  If you have a table in the data model with too many columns, I am not able to see the columns that are off the right-hand side of the screen.

    Wednesday, November 12, 2014 3:27 PM
  • Wednesday, November 12, 2014 5:08 PM
  • Thanks for providing the screen shot. This behaviour isn't normal; the horizontal scroll bar should definitely by present in this scenario.

    • Does re-sizing the Power Pivot Window cause the horizontal scroll bar to appear?
    • Does toggling between the Data View and Diagram View make a difference?
    • Does disabling and then re-enabling the Power Pivot Add-in make any difference?
    • Does the same thing happen if you create a new workbook and load the same table?
    • Have you already tried a repair on your Office installation?

    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com
    Blog: http://www.nimblelearn.com/blog
    Twitter: @nimblelearn

    Thursday, November 13, 2014 12:28 PM