Share via

ScrollArea not stored

Anonymous
2020-01-30T12:48:22+00:00

After the most recent MS Office update (currently running Version 1912 (build 12325,20344 Klik-en-Klaar)), the ScrollArea feature of sheets seems to be gone. My tests:

In a new workbook, I set the ScrollArea on my first sheet to A:Z and saved the file. Close Excel, open the file and my ScrollArea is gone.

If I check the saved file (add .zip and check the xml contents), I see in sheet1.xml:

<dimension ref="A1"/>

That's wrong, should be A:Z

Second test: when I load a file that has the ScrollArea correctly stored (checked that again with the .zip -> check sheet1.xml and see a correct dimension A:Z), Excel won't load that at all, the ScrollArea in the opened file remains empty (checked in VBE).

Sounds like an Excel bug to me, can anyone reproduce it?

[Moved from: Office / Excel / Windows 10 / Office 365 Home]

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-03T08:23:28+00:00

    Hi Andreas,

    that's indeed the solution I coded. However: for the past year that I've been working on the tool, this was not an issue as the ScrollArea was stored&loaded correctly. I overwrote it by another macro every now and then and all was stored ok. This apparently changed after the last automatic office update.

    Koen

    Was this answer helpful?

    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-02-02T10:11:30+00:00

    Known issue for years, the workaround is to set it with VBA in Workbook_Open

    https://docs.microsoft.com/en-ie/office/vba/api/excel.workbook.open

    Andreas.

    Was this answer helpful?

    0 comments