Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Refresh Issues...
I've been developing this spreadsheet for 3 or 4 months now - on and off.
Something's changed and I can't figure out what happened. What the spreadsheet does...I've written some code that uses the data located on sheet - TempData to generate 2 histograms, a run chart, and some statistics pertaining to the data. I've written the code as an Auto_Open( ) so that it works as the workbook opens. I need it to run completely without operator interaction. I've written so that once the code has been executed it closes the workbook and Excel. I've set the macro Security to LOW so that the operator doesn't have to select the "Enable Macros" button on startup. When I last worked on the spreadsheet everything was working fine. Now it's time to deploy it and I tested it today and now it seems different. The difference that I'm talking about is that now every time I open the workbook, I'm prompted with a message saying "...that the spreadsheet contains data that are linked to an external datasource. Do you want to update the datasource..." or something like that. The options are "Yes" and "No". Yes updates the data from the source file and No leaves it as it is. I don't know why I'm getting this message and the message really isn't the problem, I just need to make it so that the operator doesn't have to interact with it. Can anybody explain to me why it never prompted me before but now it always does? and How can I get past this by either changing the way the data is linked or programmically acknowledge the button? Thanks Jeff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Refresh Issues...
I checked that feature under Tools...Options. It had a check mark in the box. I removed the check mark...saved the sheet...and re-opened it. Same results. That isn't it
Thanks though |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - Refresh issues | Excel Worksheet Functions | |||
External Data Refresh Issues | Excel Discussion (Misc queries) | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |