cristitoner
New Member
- Joined
- Mar 7, 2016
- Messages
- 5
Hello,
I have a worksheet with a lot of information, and I want to make another one in the same file with some concise information, but when data is changed in the first worksheet to automatically change in the second one. I found the following sollution: copy the respective rows and paste special - paste link in the second worksheet. The problem is that half way down, I get the follwing error: "Excel cannot complete this task with available resources. Choose less data or close other applications."
My file is so far 106MB (and less than 1 mb without the second worksheet), 2138 lines, and multiple formulas and functions. The lines that I want to copy to the second worksheet are:
Total
=COUNTIFS(L66:L66,">="&1,L66:L66,"<="&2)
=COUNTIFS(L66:L66,">="&3,L66:L66,"<="&6)
=COUNTIFS(L66:L66,">="&7,L66:L66,"<="&13)
=COUNTIFS(L66:L66,">="&14,L66:L66,"<="&17)
=COUNTIFS(L66:L66,">="&18,L66:L66,"<="&24)
These lines are in total about 1000 lines. I suspect what the problem is, but I don't know the solution. Is there another way to have 2 cells in 2 worksheets to "communicate" with each other that doesn't use so many resources?
I have a worksheet with a lot of information, and I want to make another one in the same file with some concise information, but when data is changed in the first worksheet to automatically change in the second one. I found the following sollution: copy the respective rows and paste special - paste link in the second worksheet. The problem is that half way down, I get the follwing error: "Excel cannot complete this task with available resources. Choose less data or close other applications."
My file is so far 106MB (and less than 1 mb without the second worksheet), 2138 lines, and multiple formulas and functions. The lines that I want to copy to the second worksheet are:
Total
=COUNTIFS(L66:L66,">="&1,L66:L66,"<="&2)
=COUNTIFS(L66:L66,">="&3,L66:L66,"<="&6)
=COUNTIFS(L66:L66,">="&7,L66:L66,"<="&13)
=COUNTIFS(L66:L66,">="&14,L66:L66,"<="&17)
=COUNTIFS(L66:L66,">="&18,L66:L66,"<="&24)
These lines are in total about 1000 lines. I suspect what the problem is, but I don't know the solution. Is there another way to have 2 cells in 2 worksheets to "communicate" with each other that doesn't use so many resources?
