Communicating cells between worksheets - available resources problem

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?
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,109,142
Messages
5,527,069
Members
409,742
Latest member
setam

This Week's Hot Topics

Top