Hello! I have a spreadsheet that is linked to five text files.
I have created the link by using the Tool: Import Data command.
The external data is all text files.
I set the Properties for each text file link to:
- refresh automatically on file open
- not prompt for file name
This was so the spreadsheet user can copy the current text files they want to analyse and just open the spreadsheet and, voila, data is automatically refreshed without the user having to do anything.
I have developed the spreadsheet with the text files in the same folder as the spreadsheet (I have the spreadsheet in My Documents).
However, when I give the spreadsheet to the boss, and she puts the spreadsheet and text files (still in the same folder) in a mapped network folder (different from the folder that I developed in), even though the text files are sitting right there with the spreadsheet, Excel can't find them.
We have found that you must re-do the import process (Tools: Import Data) on the five text files and then Excel sees them again.
This is annoying. Anyone have any solutions?
Thanks!
This message was edited by stevesian on 2002-04-20 15:23
This message was edited by stevesian on 2002-04-20 15:24
This message was edited by stevesian on 2002-04-20 15:24
I have created the link by using the Tool: Import Data command.
The external data is all text files.
I set the Properties for each text file link to:
- refresh automatically on file open
- not prompt for file name
This was so the spreadsheet user can copy the current text files they want to analyse and just open the spreadsheet and, voila, data is automatically refreshed without the user having to do anything.
I have developed the spreadsheet with the text files in the same folder as the spreadsheet (I have the spreadsheet in My Documents).
However, when I give the spreadsheet to the boss, and she puts the spreadsheet and text files (still in the same folder) in a mapped network folder (different from the folder that I developed in), even though the text files are sitting right there with the spreadsheet, Excel can't find them.
We have found that you must re-do the import process (Tools: Import Data) on the five text files and then Excel sees them again.
This is annoying. Anyone have any solutions?
Thanks!
This message was edited by stevesian on 2002-04-20 15:23
This message was edited by stevesian on 2002-04-20 15:24
This message was edited by stevesian on 2002-04-20 15:24