Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared Workbooks and Data Queries
I have a workbook that has several data queries to external datasources. I
can either choose the Refresh Data action/button or configure my Data Qurey to automatically run every x minutes. However when I enable the workbook for sharing I lose both of these functions. I looked at the 'Features that are unavailable in shared workbooks' and it does not mention external data queries so I expected to be able to share my workbook and have excel automatically update the external data. Does anyone know if there is a way to achieve this? Thanks in advance - Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) |