No problem, interesting to know that’s how that error presents – I’ve seen a different message when I’ve had some other issues with lots of data there.
You might try the previously mentioned Trim Balance History tool – I’d be curious to see if that helps make 10 years of weekly history work. I’m not sure if the limit is on the number of rows it’s scanning (the size of balance history) or the number of scan calculations it needs to do (which is more about the number of periods of history you are calculating).
It’s kind of annoying that the built-in balance sheet doesn’t record a balance for every account every day – that’s what makes this calculation super intensive as it has to scan back in time to have a record for all of your accounts on a single day.