Sheet Updates

M1 Spreadsheet is updated over time. When a new version is available, you receive an email with the changes.

Because your copy lives in your own Google Drive, updates do not overwrite it automatically. Create a new copy of the latest spreadsheet and migrate your editable values.

Make a new copy

Follow the same steps from Getting Started and create a fresh copy of the updated spreadsheet.

Move your values

For each sheet where you entered values, such as Stocks, Portfolio, and Dividends:

1. Select the yellow cells you edited in the old spreadsheet.
2. Copy them.
3. Open the new spreadsheet.
4. Select the same range.
5. Right-click and choose Paste special > Values only.

Do not paste formulas or formatting from the old file into the new one. Copy values only.