Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy range of cells omitting formulas that result in " " | Excel Discussion (Misc queries) | |||
loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |