Gerrit-Jan Linker
|
Workbook contains links to other data sources. Question: In a workbook in which I have used the SQLQueryValue function I am getting the following Excel warning when I next open the workbook (xls): [tt]This workbook contains links to other data sources If you update the links, Excel will attempt to retrieve the latest data If you don't update the links, Excel will use the previous information. Note that data links can be used to access and share confidential information without your permission and possibly perform other harmful actions. Do not update the links if you do not trust the source of this workbook. Update - Don't Update - Help Answer: When using a SQL*XL function like SQLQueryValue Excel will save a link to the SQL*XL software. It remembers which plugin / addin provided the function results. When you start Excel when you have not used SQL*XL yet, the function needs to load SQL*XL in to be able to recompute its value. This is what this message relates to. Do you want SQL*XL to refresh the values or do you want to just use the last results at the time you saved this workbook. I suggest you always say don't update here. If you have not established a connection to the correct database yet in SQL*XL the commands will likely fail.
|