Skip to main content
All CollectionsExtendInsights for Analytics NetSuiteTroubleshooting
Troubleshooting: Won't work because it would move cells in a table on your worksheet
Troubleshooting: Won't work because it would move cells in a table on your worksheet

ExtendInsights Analytics | Troubleshooting when getting 'Won't work because it would move cells in a table on your worksheet' error

Updated over 3 months ago

When you have a scheduled worksheet it is important to not apply filters or hide any rows. This will have an impact on pulling saved searches from NetSuite to your Excel worksheet.

Error

Wonโ€™t work because it would move cells in a table on your worksheet.

Reason for the error

The error could have occurred for the following reasons.

  • You have applied filters to your worksheet.
    To resolve this, remove the filters and manually refresh your data to get the latest results.

  • You have hidden rows in the worksheet.
    To resolve this, unhide all rows and manually refresh your data to get the latest results.

  • There is a delay in our application communicating with Microsoft.
    To resolve try again.

๐Ÿ‘‰ See other common errors encountered when downloading Saved Searches from NetSuite.

Other

Please note that we do recommend limiting access to your source file. By using tools like Excel Power Query to connect to your source file you can filter rows, hide them, etc., without impacting ExtendInsights ability to update your source data.

๐Ÿ‘‰ Learn more here.

Did this answer your question?