QUOTE(jutamind @ May 3 2015, 11:23 AM)
Guys,
I'm trying to move my records from v1.6 to v1.7.
While trying to copy a set of new fund to the placeholder line in v1.7 xls file (copy A17:P22 and insert copied cells to line 195), I get the error "The operation is not allowed. The operation is attempting to shift cells in a table in your worksheet".
Any idea why? I tried the same copy and insert in v1.6 and have no such issues...
I'm trying to move my records from v1.6 to v1.7.
While trying to copy a set of new fund to the placeholder line in v1.7 xls file (copy A17:P22 and insert copied cells to line 195), I get the error "The operation is not allowed. The operation is attempting to shift cells in a table in your worksheet".
Any idea why? I tried the same copy and insert in v1.6 and have no such issues...
QUOTE(yklooi @ May 3 2015, 12:01 PM)
QUOTE(jutamind @ May 3 2015, 03:44 PM)
yklooi, yes, i'm copying the cells from A17 to P22 and then insert copied cell on line 195, and i got the error.
i tried the same copying of cells from A17 to P22 in v1.6xls and insert copied cell on line 195 and it works.
i tried the same copying of cells from A17 to P22 in v1.6xls and insert copied cell on line 195 and it works.
QUOTE(yklooi @ May 3 2015, 07:31 PM)
When you copy from v1.6 file to v1.7; don't select A:P (example A17 to P22); but instead, only select A:I (example: A17 to I22)! As the rest of the columns are either contains formula; or are not available in v1.6 (example the GST column).Also, never ever replace formula's in different spreadsheet as the formula's might have been updated, and overriding them will cause the spreadsheet to be using wrong / old formula. Always stick with the white columns (data entry columns) only.
May 4 2015, 05:31 PM

Quote
0.0347sec
0.53
6 queries
GZIP Disabled