Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Max sheets in a workbook or max # of calculated cells
I have a excel model that runs company scenarios. It currently has about 90
sheets and I am hitting the difficultly of calculations not updating. For example, I will make a change in one sheet that is referenced in another.. When I check the sheet that calls the first number, it has not changed. If I hit F2 and then enter in the cell in question, it will show the updated number... I have many inputs and this can cause a huge problem as there seems to be no warning. In using the "info" command it would seem that i am using a huge percentage of available memory.. It is a memory issue with the number of sheets in the book or that there are too many calculated cells for a change to get calculated through? Thanks, |
#2
|
|||
|
|||
Hi Phil,
Check this site: www.decisionmodels.com Kind regards, Niek Otten "phil g" wrote in message ... I have a excel model that runs company scenarios. It currently has about 90 sheets and I am hitting the difficultly of calculations not updating. For example, I will make a change in one sheet that is referenced in another.. When I check the sheet that calls the first number, it has not changed. If I hit F2 and then enter in the cell in question, it will show the updated number... I have many inputs and this can cause a huge problem as there seems to be no warning. In using the "info" command it would seem that i am using a huge percentage of available memory.. It is a memory issue with the number of sheets in the book or that there are too many calculated cells for a change to get calculated through? Thanks, |
#3
|
|||
|
|||
Thanks,
I had already checked that site out... But was wondering if there was a way to check what the limit was or how close I was to it. "Niek Otten" wrote: Hi Phil, Check this site: www.decisionmodels.com Kind regards, Niek Otten "phil g" wrote in message ... I have a excel model that runs company scenarios. It currently has about 90 sheets and I am hitting the difficultly of calculations not updating. For example, I will make a change in one sheet that is referenced in another.. When I check the sheet that calls the first number, it has not changed. If I hit F2 and then enter in the cell in question, it will show the updated number... I have many inputs and this can cause a huge problem as there seems to be no warning. In using the "info" command it would seem that i am using a huge percentage of available memory.. It is a memory issue with the number of sheets in the book or that there are too many calculated cells for a change to get calculated through? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 sheets in workbook, but visible only one? | Excel Discussion (Misc queries) | |||
Copy formatted in several sheets of a workbook | Excel Worksheet Functions | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
Sending sheets in workbook | Excel Discussion (Misc queries) | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) |