try this page#55 post #1093
https://forum.lowyat.net/topic/3509481/+1080

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.

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.

When you copy those cells, do you already have enough 'rows' (placeholders) equivalent to number of rows / data you are copying?

If yes, it shouldn't even pop up to shift cells because you are merely replacing the dummy data in new file, with figures in the old sheet.

Nope, there are no errors.

Basically when you paste it, just make sure you are pasting it as values onto EXISTING cells, not trying to paste and let excel "Create" these new cells for you.

Below is an illustration on how to copy-and-paste.

@jutamind

no expert but your second image has

AMB Income Trust Fund
Dummy Fund A
and you tried to paste on this row.

but the original template should be 
you try to paste on this row <--- at least how i do it
CIMB-Principal Asia Pacific Dynamic Income Fund
AMB Income Trust Fund
Dummy Fund A
Fund A with MANY rows for U to Use
Fund B many rows.. Self copy
PLACEHOLDER: DO NOT TOUCH

your first image - i believe you are not suppose to copy row 11?
CIMB-Principal Asia Pacific Dynamic Income Fund at row 11 is default and present in original template and has formula etc? <-- everyone has this row in their template.

maybe you should download a fresh template again and start over.

Basically, using your example (I assume step 1 is old file with manual added gst column)

1) select cell A3 to I10 (not 11!!) and copy these cellw
2) do not right click on line 23. If you have enough empty lines already, just select cell A23 and paste as values (refer previous screenshot)

Basically doing the above, it should not pop the shift cell as long as you have enough rows. The reason you should exclude line 11 because it's a formula row, so do not ever copy it directly.

Let me know if it works.

i created new rows, then copy the whole set of funds, paste botm, then edit name etc..
when need to add space..
I add lines in between..
then copy top and paste