Thread
:
Data Refresh Issues...
View Single Post
#
2
Posted to microsoft.public.excel.programming
Mark Rosenkrantz[_2_]
external usenet poster
Posts: 33
Data Refresh Issues...
Jeff;
I'm not shure if this is it, but trying it might help.
In the Menu click | Options
Select the Tab Calculations
In Workbook Options check Update Remote References.
I thought that that was the one ...
Mark.
More Excel ?
www.rosenkrantz.nl
or
--------------------------------------------------------------------
"Jeff Harbin" wrote in message
ink.net...
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
Reply With Quote
Mark Rosenkrantz[_2_]
View Public Profile
Find all posts by Mark Rosenkrantz[_2_]