ExcelAtEverything
Active Member
- Joined
- Jan 30, 2021
- Messages
- 351
- Office Version
- 2019
- Platform
- Windows
Hello,
I have a year's worth of sales reports for 4 stores to be analyzed by Power Query and eventually end up in Power Pivot via Data Model.
With regards to CPU strain & length of time to refresh, should I use Folder A, or Folder B, or does it not matter?
--> In Folder A, there are 4 total reports: 1 for each store with a date range of 01/01/2020 - 12-31-2020. Each file is 60MB.
--> In Folder B, there are a total of 48 reports: 12 for each store w/ each file covering one single month. Each file an equal fraction of the same 60MB total.
Thanks!
I have a year's worth of sales reports for 4 stores to be analyzed by Power Query and eventually end up in Power Pivot via Data Model.
With regards to CPU strain & length of time to refresh, should I use Folder A, or Folder B, or does it not matter?
--> In Folder A, there are 4 total reports: 1 for each store with a date range of 01/01/2020 - 12-31-2020. Each file is 60MB.
--> In Folder B, there are a total of 48 reports: 12 for each store w/ each file covering one single month. Each file an equal fraction of the same 60MB total.
Thanks!
