Hi All,
Could you please help me with the issue below
I did some excel formulas which linked to an external excel file. when both files are open the formula will be auto adjusted (example if I insert a column, the formulas will be auto shifted to next column accordingly). however, when i have only the linked filed opened if i insert more columns, the other files that i have formulas won't be auto adjusted.
Thanks for your help!
Could you please help me with the issue below
I did some excel formulas which linked to an external excel file. when both files are open the formula will be auto adjusted (example if I insert a column, the formulas will be auto shifted to next column accordingly). however, when i have only the linked filed opened if i insert more columns, the other files that i have formulas won't be auto adjusted.
Thanks for your help!