Forum Discussion
925stuart
Helper I
2 years agoCan I disable load to speed things up?
Hi,
I've been using dataset.xls to build visuals. dataset.xls is hitting Excel's technical limit so I'm now directing new data to a new file dataset2024.xls. I'm appending dataset2024.xls to dataset.xls. Given that dataset.xls is now going to be static, i.e. no more new data will be added to it, can I disable load to speed things up?
4 Replies
- 925stuart
Helper I
It seems like I should exclude in report refresh instead?
- mussaenda
Community Champion
- 925stuart
Helper I
Since I'm appending dataset2024.xls to dataset.xls, would disabling refresh of dataset.xls also disable the refresh of dataset2024.xls?
- mussaenda
Community Champion
before appending, exclude the report refresh on the dataset that is static before appending it to your 2024 data. Make sure that you'll be appending it to your 2024 data and not the other way around.