T
txheart
Hi y'all,
I did search, but I didn't find one that fit my situation close enoug
to be comfortable with, and was afraid to do something that might mes
everything up.
I work in an insurance company. We have 7 people in the office and w
all share a network drive, as well as having the regular c drive on ou
computers. All of the important business documents are kept on th
network drive. We have multiple contact databases; one for agents, on
for clients, one for insurance providers, etc. There are 7 altogether
Only one person can open the file in edit mode at a time. I rarel
edit, but I do use them extensively every day. When I open the file, i
I'm the first to do it that day, I get the edit capabilities, then a
asked if I can get out of it so that someone else can edit it.
I've made a workbook with 7 worksheets, each tab(sheet) named after on
of the databases on the network. I'd like to have Excel automatically d
an update from the master every time I open the worksheet file in th
morning. This way I will always have the correct information to do m
job, but they'll all be in one book and I won't have to exit it to le
someone else in. I've cut and paste, but that won't update. I've trie
linking, but I can't figure out how to do it for the whole shee
instead of just a few cells. I'm now using import data, but it doesn'
update either, does it? I do need the updates...
Does anyone know how I can get the information that I want? I could cu
and paste every morning, but I'm sure Excel has an easier, automated wa
to get the files, right? Thanks so much for your help!
~K
I did search, but I didn't find one that fit my situation close enoug
to be comfortable with, and was afraid to do something that might mes
everything up.
I work in an insurance company. We have 7 people in the office and w
all share a network drive, as well as having the regular c drive on ou
computers. All of the important business documents are kept on th
network drive. We have multiple contact databases; one for agents, on
for clients, one for insurance providers, etc. There are 7 altogether
Only one person can open the file in edit mode at a time. I rarel
edit, but I do use them extensively every day. When I open the file, i
I'm the first to do it that day, I get the edit capabilities, then a
asked if I can get out of it so that someone else can edit it.
I've made a workbook with 7 worksheets, each tab(sheet) named after on
of the databases on the network. I'd like to have Excel automatically d
an update from the master every time I open the worksheet file in th
morning. This way I will always have the correct information to do m
job, but they'll all be in one book and I won't have to exit it to le
someone else in. I've cut and paste, but that won't update. I've trie
linking, but I can't figure out how to do it for the whole shee
instead of just a few cells. I'm now using import data, but it doesn'
update either, does it? I do need the updates...
Does anyone know how I can get the information that I want? I could cu
and paste every morning, but I'm sure Excel has an easier, automated wa
to get the files, right? Thanks so much for your help!
~K