Sep 13 2019 02:15 PM
Is there a way that when a file view web part is added to a modern page to insert a spreadsheet that when the spreadsheet is open it will automatically open to the first workbook to a certain cell? Right now it opens on the second workbook, or will open on the first workbook but scrolled half way to the right.
I've tried saving the originating spreadsheet with cell A1 selected in the first workbook. Does not work with opening in the app or online or via a web part
I've tried adding VB code to the originating workbook to open A1 in the first workbook. This works when opening the file in the app, but not online or via a web part.
Private Sub Workbook_Open()
Worksheets("First Workbook").Activate
Range("A1").Select
End Sub
Sep 13 2019 03:20 PM
Hi @LawrenceNapier,
There are options in "File Viewer" web part that will allow you specify a starting sheet and range. See image below.
More information located here: https://support.office.com/en-us/article/connect-web-parts-in-sharepoint-online-b457668c-d843-4b1b-8....
I hope this helps.
Norm