Long Formula in cell and REF!

[rodich]

Dear all,
I have some sheets with raw (source) data. First I copy them from the external XLS or MHTML file. I have button with macro for these actions.
I the next sheets I calculate Initial/Final Balance with static formulas in cells with fields from source or from custom fields.

I lost some of the columns when I replace data with in source sheets ....

=D2+SUM(SUMIFS(DB_001!$M:$M;DB_001!#REF!;B2;DB_001!$R:$R;">=1";DB_001!$R:$R;"<=3";DB_001!$N:$N;{"ZC02","PAL"}))+SUMIFS(DB_002!$J:$J;DB_002!$B:$B;"ZCG2";DB_002!#REF!;">=1";DB_002!#REF!;"<=3";DB_002!$F:$F;B2)-(--SUM(SUMIFS(DB_002!$J:$J;DB_002!$B:$B;{"ZPAL","ZC02"};DB_002!#REF!;">=1";DB_002!#REF!;"<=3";DB_002!$F:$F;B2))-(-SUMIFS(DB_003!#REF!;DB_003!$E:$E;B2;DB_003!$F:$F;">=1";DB_003!$F:$F;"<=3")-(SUMIFS(DB_001!$M:$M;DB_001!#REF!;B2;DB_001!$R:$R;">=1";DB_001!$R:$R;"<=3";DB_001!$N:$N;"ZCR1"))))

I dont understand why ?!?!
How can I avoid it?
Thank you in advance for help!!

[Admin]

Check the macro in which any columns get deleted. Try to clear the columns rather than delete, which causes the REF error.

[rodich]

Ok. I'll try to make the formulas in first step and after that will try to delete
Thak you for advice!!