Hi,
I run into two issues at the moment.
The first issue:
I have two excel files.
-The first is used to enter data by a user. This data is then in a number of hidden sheets used to calculate a few things and finally presented in the last sheet, viewable by the user.
-The second file uses the final data from the first sheet and selects a part of it based on a simply criteria (variable <> 0). This is al dynamic, since the user can change data in the first file.
The first file by itself works fine.
The second file, when initially made, works fine as well: I enter the relevant formulas and these calculate correctly the relevant numbers. However, when updating anything, anywhere, the second file goes blank. The formulas are still there, but nothing happens. I can press enter, ctr+shift+enter, etc all I want, all cells are blank. When I remove all content from the cells and put in the formulas again, it shows again correctly. But this is not desirable, since cells should be updated dynamically without any user action.
Some extra info:
-When in the second file formulas are inserted, they calculate very slowly. They do it correctly, but takes several minutes to complete and I have to click/perform some action, to see that anything happened at all. Before I made the second file, cells in the first file updated just fine.
-The first file is 2.2mb, the second 570kb.
-The first file has 5 sheets, all with about 1500 rows*50 columns with formulas.
-The second file has two sheets, both with about 1500 rows*6 columns formulas.
I suspect it has something to do with instances but I'm not entirely sure. Since the formulas calculate very slowly anyway, I suspect I have done something inefficient.
The second issue:
When I try saving any of the two files, excel freezes. I can do nothing but press escape, only then do I get the error 'calculation is incomplete. recalculate before saving'.
If I then choose 'save without calculating' the file will save.
If I turn on 'update manually' and then press 'calculate sheet' nothing happens (this is a strategy I came across).
I run into two issues at the moment.
The first issue:
I have two excel files.
-The first is used to enter data by a user. This data is then in a number of hidden sheets used to calculate a few things and finally presented in the last sheet, viewable by the user.
-The second file uses the final data from the first sheet and selects a part of it based on a simply criteria (variable <> 0). This is al dynamic, since the user can change data in the first file.
The first file by itself works fine.
The second file, when initially made, works fine as well: I enter the relevant formulas and these calculate correctly the relevant numbers. However, when updating anything, anywhere, the second file goes blank. The formulas are still there, but nothing happens. I can press enter, ctr+shift+enter, etc all I want, all cells are blank. When I remove all content from the cells and put in the formulas again, it shows again correctly. But this is not desirable, since cells should be updated dynamically without any user action.
Some extra info:
-When in the second file formulas are inserted, they calculate very slowly. They do it correctly, but takes several minutes to complete and I have to click/perform some action, to see that anything happened at all. Before I made the second file, cells in the first file updated just fine.
-The first file is 2.2mb, the second 570kb.
-The first file has 5 sheets, all with about 1500 rows*50 columns with formulas.
-The second file has two sheets, both with about 1500 rows*6 columns formulas.
I suspect it has something to do with instances but I'm not entirely sure. Since the formulas calculate very slowly anyway, I suspect I have done something inefficient.
The second issue:
When I try saving any of the two files, excel freezes. I can do nothing but press escape, only then do I get the error 'calculation is incomplete. recalculate before saving'.
If I then choose 'save without calculating' the file will save.
If I turn on 'update manually' and then press 'calculate sheet' nothing happens (this is a strategy I came across).