It seems I’ve reached the limitations of Excel as it no longer works the way I require.
Basically I have a single controlling spreadsheet which controls many other spreadsheets. As I manipulated numbers in the controlling spreadsheet it modifies all the other spreadsheets and I get the results of the changes via a few graphs and tables. I basically tune the numbers to get a desired result on the graph.
The problem is in order for this to work I have to have all spreadsheets open at once. It worked up to about 100 or so spreadsheets but now I’m up to 500 spreadsheets therefore I can no longer refine the model without doing it in blocks of 100 at a time.
I’m wondering whether there is an alternative software that would either be able to handle more spreadsheets being open at once (or perhaps they can interact without being open), or whether I need to look at converting my spreadsheets into another format.
I also tried converting multiple spreadsheets into one single file but it seems that the limitations are due to the complexity of the spreadsheets and not the number of spreadsheets that I have open.
Any suggestions?
Basically I have a single controlling spreadsheet which controls many other spreadsheets. As I manipulated numbers in the controlling spreadsheet it modifies all the other spreadsheets and I get the results of the changes via a few graphs and tables. I basically tune the numbers to get a desired result on the graph.
The problem is in order for this to work I have to have all spreadsheets open at once. It worked up to about 100 or so spreadsheets but now I’m up to 500 spreadsheets therefore I can no longer refine the model without doing it in blocks of 100 at a time.
I’m wondering whether there is an alternative software that would either be able to handle more spreadsheets being open at once (or perhaps they can interact without being open), or whether I need to look at converting my spreadsheets into another format.
I also tried converting multiple spreadsheets into one single file but it seems that the limitations are due to the complexity of the spreadsheets and not the number of spreadsheets that I have open.
Any suggestions?