ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cannot copy or move array entered formulas ... shared workbk (https://www.excelbanter.com/excel-worksheet-functions/27956-cannot-copy-move-array-entered-formulas-shared-workbk.html)

JimDerDog

Cannot copy or move array entered formulas ... shared workbk
 
Hi all
I have a fantastically complicated spreadsheet covered in 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 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


All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com