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.



Attached thumbnail(s)

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.

1) The steps I mentioned is to copy the fund details from old spreadsheet to new spreadsheet

2) As you said, the default excel comes with only 5 SET of FUNDS. To add more funds, refer to the guide in the excel file on "How to add new SET of FUNDS".

Basically in a nutshell, what you need to do is:-

1) Go to new excel file, create 5 SET of funds.
2) After you created 5 SET of funds, ensure these total "10 SET of funds" have enough number of "Rows" to accommodate the funds currently in the old spreadsheet.
3) Once you have enough rows (example: Fund 1 = 10 data rows, Fund 2 = 3 data rows, fund 4 = 15 data rows, etc...), copy the fund DATA (exclude subtotal row please), a fund at a time. (example: copy cell A3 to I10 for Fund A, paste in new spreadsheet; then repeat same steps for the rest of the funds).

Technically if you are excel-savvy, you can manually add a column in v1.6 and modify the formulas, but only if you are familiar enough with the file. I'd advise against that and rather copy the funds data 10 times (one set at a time) to avoid errors.

jutamind I think I know why you kept getting the "Attempt to shift table cell" error already, even after following the instructions.

This is because the Excel version of yours is 2010, I remember woonsc encountered the same error but managed to resolve it,

woon, do you mind sharing how you add new set of funds into the template? Since the method I shared only works for Excel 2013++.