The Add-On for Google Sheets will not open and allow us to connect from large workbooks. It only seems to work with smaller/single sheets. Has anyone else experienced this? Is this a limitation of the add-on?
Hi, there are standard Google Sheets limits for worksheets applicable. You're limited to:
There's no limit to the number of rows you can have in a worksheet. You cannot create a connection to a module that contains a dimension with more than 1 million items.
Note: A connection between Anaplan and a new worksheet uses at least 26,000 cells from the 1 million in the worksheet. This is to protect any custom data you enter into cells outside the data you retrieve from Anaplan.
For more details refer the following Link: