View Single Post
Old 05-10-2021, 09:06 AM   #992
DaltonS's Avatar
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
Default Re: GURPS Spaceships Design Spreadsheet

Originally Posted by ericbsmith View Post
Open both the old spreadsheet and the new version in Excel at the same time (e.g. you might open both RC 30 and RC 33 together).

Older versions of Excel had some memory issues with doing this with large sheets (which this is). So what you can do is delete all of the sheets from the older spreadsheet except for the Saved Ships Sheet before opening it (I recommend saving it to a new file at this point, closing it, then reopening it).

Once you've opened both spreadsheets you will need a Saved Ships sheet with enough room to import all of the ships; you can either create a new Saved Ships sheet or delete all of the ships from within the Official or Unofficial Ships sheets. Once you have that, you can click the Import Saved Ships button in the Saved Ships sheet, and it will ask you which file you're importing from, which Saved Ships sheet in that file you're importing from, and which Saved Ships sheet in the current spreadsheet you're importing to.
You might want to consider adding this explanation to the "Optional Rules" sheet as it is something every user will want to do when they open a new edition of the spreadsheet.
Dalton “Happy Mother Ocean Day!” Spence
DaltonS is offline   Reply With Quote