Im having trouble experimenting with an excel spreadsheet for the first time set up by a remote colleague.
He's shared a spreadsheet with me.
I've copied the link into data sources but realised it needs an API and credentials enabling etc.
Now - do I generate this or him? We've tried both ways but says "remote server returned an error 403 Forbidden)
Should this all be done before the spreadsheet is shared - or doesn't it matter.
Once the API key is in, will it be the same API key for all spreadsheets in the future?