I need to use a shared spreadsheet which cannot be modified.
Is there any way for me to reference the external data and add additional columns in another spreadsheet?
In addition, the external data is really messy. I created a pivot table in my spreadsheet. I assume I can't add data to the pivot table.
Can you recommend how I can work with this data?
