Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 23rd 05, 07:51 PM
tinkertoy
 
Posts: n/a
Default Refresh Imported Data - Does the Excel file have to be open?

This probably sounds dumb - I have a spreadsheet that I have imported data
from an existing dsn/odbc, I set the properties to refresh every 24 hours
(1220 minutes), and on open. The file is going to be used for an orgchart in
another program that imports the data from excel. I am testing that
automation also, it has tasks that refresh the data from the excel file. What
I don't know is if the excel spreadsheet has to be open for the refresh to
occur? That is not a problem, so far, but not sure yet if I can refresh the
orgchart file if the excel file is open. The files will all be on a server
that is available 24/7. Thanks!
--
Rona/tinkertoy

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting message can't save all data in excel xls file Melody05 Excel Discussion (Misc queries) 2 June 29th 05 12:20 PM
no data in excel file i.g.o.r Excel Discussion (Misc queries) 1 June 14th 05 03:41 PM
how to imort data in to excel file from other excel file? djm Excel Worksheet Functions 1 May 18th 05 05:28 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:01 PM
how to create button commande to refresh data in query in excel 2. Jean-Francois Excel Discussion (Misc queries) 1 January 6th 05 08:03 PM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017