Note: If you wish to import lookup tables or time history data from a spreadsheet into GoldSim, or export time history data from GoldSim to a spreadsheet, GoldSim provides specialized ways to do this using the Lookup Table, Time Series and Time History Result elements that do not require a Spreadsheet element. 

   Note: GoldSim supports .xlsx, .xlsm, and .xls Excel files. However, if you have an older version of Excel (prior to Office 2007), you will need to install Microsoft’s Office Compatibility Pack in order to read .xlsx and .xlsm files.  Excel 2007 and later support a larger worksheet size (1,048,576 rows by 16,384 columns) than earlier versions (65,536 rows by 256 columns).  If you wish to exchange data between an extended worksheet range and GoldSim, you must use Excel 2007 or newer, and the file format must be .xlsx or .xlsm. Note that GoldSim does not officially support versions of Excel prior to Excel 2003.

   Warning: You should never try to open a spreadsheet that is linked to GoldSim while a simulation is running.  In addition, prior to running a GoldSim model that is linked to a spreadsheet, all referenced spreadsheets should be closed. If you try to interact with a spreadsheet that is being used by GoldSim during a simulation, all interaction with the spreadsheet is blocked by GoldSim. However, under some circumstances this may not be possible and could lead to errors. Hence, as a general rule, you should not use Excel while a Goldsim model that references Excel is running.

   Warning: You should not specify Excel files with the same filename that are in different folders, drives or network locations (e.g., using two different Spreadsheet elements). Excel is unable to open such files simultaneously, and this will cause GoldSim to fail.