J
JimDerDog
Hi all
I have a spreadsheet which uses several array formulas which I have now
shared to enable change tracking by the multiple users across our network.
It works as a year planner with staff names across the top and dates down
the side.
One of the things the users need to do is add columns (with array formulas
in each) to this spreadsheet in specific places when new staff join. This was
not a problem before I turned on change tracking and it was opened
exclusively each time, but now I get the message saying I cannot copy across
the array formulae at the top of column.
Temporarily removing it from shared use, adding the column and re-sharing is
a bit clumsy, loses the change track data and would need me to do it, rather
than this being self-service.
Can anybody help?
Please?
JimDerDog
I have a spreadsheet which uses several array formulas which I have now
shared to enable change tracking by the multiple users across our network.
It works as a year planner with staff names across the top and dates down
the side.
One of the things the users need to do is add columns (with array formulas
in each) to this spreadsheet in specific places when new staff join. This was
not a problem before I turned on change tracking and it was opened
exclusively each time, but now I get the message saying I cannot copy across
the array formulae at the top of column.
Temporarily removing it from shared use, adding the column and re-sharing is
a bit clumsy, loses the change track data and would need me to do it, rather
than this being self-service.
Can anybody help?
Please?
JimDerDog