auto update xls document from separate file

  • Thread starter Thread starter kaplonk
  • Start date Start date
K

kaplonk

What I want to do is have one separate xls file to use as a database,
then when any changes are made to this file, have other files
automatically update, without actually opening them and separatly
adding the data.
Is this possible?
 
kaplonk,

No. You must open an Excel file to change it. You could have the change
happen automatically when you _do_ open it, but you must open it.

HTH,
Bernie
MS Excel MVP
 
And it becomes a real pain to keep all the workbooks in sync. (If the other
file is in use, how do you keep track of those changes.)

If I were you, I'd try my best to keep all my data in one spot. If you need
other "report" workbooks, it's usually much easier starting with the combined
data and extracting info when you need to. (But these report workbooks are just
reports--no updates would be saved to the real data.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

one workbook, multiple .xls files 1
Is it possible to load sheet without update links? 2
Importing Data from a pre-existing spreadsheet 2
Update data without opening file? 1
Not updating Files from correct folder 1
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Build a link to an other excell document. 1
Issue with save xls file to html and than back to xls 1

Back
Top