Many of our users like to send their spreadsheets to colleagues and others that do not have access to the YCharts Excel add-in. For someone to access a spreadsheet that links to YCharts you must "flatten" it first.
Important Note: Flattening a spreadsheet is irreversible and removes all the formulas in the spreadsheet. Always save a separate version of your spreadsheet before flattening.
Steps to flatten the spreadsheet:
1. Save a separate version of your spreadsheet; refer to the note above.
2. Select the cells you would like to flatten. If you are flattening multiple tabs you will have to do each tab separately.
2. Keeping the cells highlighted, locate the "Flatten" button in the YCharts tab.
3. Save this version of your spreadsheet, it's ready to be sent to others!