I want to a spreadsheet to pick up details from another one held on a web server. I have access to the file so that is not an issue.
When I go to sheet-> link external data it gives me the chance to enter the URL of the external data source. When I enter the location of the ods file the OK button remains greyed out, there are no available tables/ranges. What am I doing wrong?