I created a CALC file with a main sheet containing data coming from a VIEW in BASE (DataSource). Other sheets contain graphs based on data from the 1st sheet.
Later, I created a query in BASE and I decided to switch the Data Source of the CALC sheet and read data from that query, instead of the view. Data are in fact read as expected.
Finally I deleted the view in CALC.
Now, everytime I open the CALC sheet I get twice the warning message:
“It wasn’t possible to load data contents. No tables named “xxx” exist” (personal translation from Italian, hence the english message may be lightly different…).
How can I avoid it? I really don’t know where the link to the old view is still present.
Open the Calc document, navigate to the linked database range (menu:Data>Select…), open the data source window (Ctrl+Shift+F4) and drag the query icon onto the database range.
A confirmation dialog asks if you want to replace the old link with the new one.