2

I placed an Excel Web Part on one of my pages. Whenever it loads, the bottom scroll bar (the one that goes left and right) is not at the far left side (where the default usually is), but it's in the middle, requiring that the user scroll left to see the entire worksheet section.

When I pulled up the Excel file that the web part feeds from, it comes up on the left side.

  • Has anyone else run into this situation?
  • Is there something I can do about this?
1

I suppose the issue is caused by the excel will record the last used cell when saving the file. When opening the file again, it will automatically redirect to that cell. So that, it will automatically navigate to the middle of the excel file when opening it using Excel web part because the last used cell is in the middle.

You can follow the steps below to reproduce that:

  1. Create a excel file and enter some data in it.
  2. Click in a cell, for example, cell R5, and then save the file.
  3. Upload the file to a SharePoint library.
  4. Open the file from the library, you will find it will automatically active cell R5 and it will be scrolled to the R5 to make it available in the screen.
  5. Render this file using the Excel web part, the same situation. It will automatically active cell R5 and it will be scrolled to the R5 to make it available in the screen.
  6. Edit the file and click in the cell D5, then save the file. The last used cell is changed to D5. When opening the file again, the cell D5 will be active.

You can locate the cell at the beginning of the worksheet section when saving. Upload this file and use this file in Excel web part, the issue should be resolved.

  • Strangely enough, this worked. I edited A2, saved it, and voila! Of course, I went and used a named range after this, so scrolling wasn't an issue anymore. But this did the trick - and should have been obvious, but you know how that goes. Thanks! :) – DanJ Sep 19 '18 at 14:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.