| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
auto update xls document from separate file
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 ------------------------------------------------------------------------ kaplonk's Profile: http://www.excelforum.com/member.php...fo&userid=9283 View this thread: http://www.excelforum.com/showthread...hreadid=376235 |
|
#2
|
|||
|
|||
|
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 "kaplonk" wrote in message ... 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 ------------------------------------------------------------------------ kaplonk's Profile: http://www.excelforum.com/member.php...fo&userid=9283 View this thread: http://www.excelforum.com/showthread...hreadid=376235 |
|
#3
|
|||
|
|||
|
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.) kaplonk wrote: 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 ------------------------------------------------------------------------ kaplonk's Profile: http://www.excelforum.com/member.php...fo&userid=9283 View this thread: http://www.excelforum.com/showthread...hreadid=376235 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update from source when file opens | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| File asks to update when no links were created | Links and Linking in Excel | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
| i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) | |||
Linear Mode
