Forum Discussion
Data tables
Hello,
I've an excel file with several big data-tables. I disabled the calculation of the data-tables from the "Formula" tab, selecting "Automatic except for data-tables".
The problem is that everytime I save the file, the data-tables are recalculated, delaying the process a lot. I think this was not happening some time ago.
Anyone knows how to solve this problem or if it is a problem related to current version update?
Thanks!
Javier
4 Replies
Your question provokes yet another question in my mind, a question having to do with what you mean by the word "data." I think of data as "resolved pieces of information" -- i.e., pieces of information that may be used as the basis for calculations, but not needing or deserving or warranting any calculation in themselves. Data is set. Period. (In my definition.)
That apparently is not the case in your file.
But, would it be safe to presume that at least some of the elements in your big tables DO meet my definition? And if so, can those be separated out into a "set in concrete" data file (or two)? Would that make any difference?
Hi!
First of all, thanks for your reply!
The name "Data tables" may be a little bit misleading. The function/option I was referring to is in:
"Data" tab --> "What-If Analysis" --> "Data Table"
Those are tables that, by definition, have only calculated cells.
I don't know if you can help me with this topic.
Thanks anyhow.
Regards,
Javier
I don't know if you can help me with this topic.
Not without more information. Is it possible for you to put a copy of your files on OneDrive or GoogleDrive (or some other cloud service) and grant access to it?
