Forum Discussion

brccoll's avatar
brccoll
Copper Contributor
Nov 07, 2019
Solved

Make Excel Office 365 open at cell A1? Or create a hyperlink to it?

Hi, I'm guessing it's a feature that shared Office 365 Excel workbooks open where someone last clicked a cell but we really need it to open at cell A1 every time.   Is it possible to either Forc...
excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 08, 2019

    brccoll 

    for the external URL add

    &activeCell=%27Sheet1%27!A1

    at the end of it.

brccoll's avatar
brccoll
Copper Contributor
Nov 08, 2019

Riny_van_EekelenThank you. An ingenious solution!  Unfortunately it's really the shared online documents I'm trying to get working sensibly and it looks like VBA code won't run https://support.office.com/en-us/article/Work-with-VBA-macros-in-Excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343

 

It also looks like https://answers.microsoft.com/en-us/msoffice/forum/all/external-url-link-to-a-specific-cell-in-an-excel/3c5d27e8-ffb9-4a7b-8cf7-5b64ce5b0814 isn't possible?

 

The best I've managed to find, is to just freeze the top left cells I need displayed at launch.  A fairly ugly solution that still doesn't guarantee the workbook doesn't just randomly load to a different tab.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 08, 2019

brccoll 

for the external URL add

&activeCell=%27Sheet1%27!A1

at the end of it.

  • brccoll's avatar
    brccoll
    Copper Contributor
    Nov 12, 2019

    SergeiBaklanThank you!  That solved our problem! 🙂

      • brccoll's avatar
        brccoll
        Copper Contributor
        Feb 09, 2022

        Has &activeCell='Form1'!A1 stopped working now.
        Can't seem to get it to open in A1 cell on a specific tab anymore.
        Tab name is correct and I've tried a couple of browsers

Resources