Updating spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that is only accessible to my boss and I. There is
another manager who needs to see 1 tab in this spreadsheet every day, as new
information is put in. Since he doesn't have access to the main spreadsheet,
I transfered the info from that tab to a new spreadsheet via lookups. This is
fine, except the other manager cannot update this new sheet, b/c he cannot
access the original information that the lookups point to. My question is: is
it possible to have the new spreadsheet update automatically from the
original one so that the manager can see new info without being prompted to
update?
 
Not really, he will need to use Edit / Links / Update Links to pull in any
new data, and that will only work if the data has been saved in the orig
workbook. He needs to update each time he wants to use it, but that is
hardly an onerous chore?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Sigh...well, thanks for the response.

Ken Wright said:
Not really, he will need to use Edit / Links / Update Links to pull in any
new data, and that will only work if the data has been saved in the orig
workbook. He needs to update each time he wants to use it, but that is
hardly an onerous chore?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
Click to expand...
 

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

Lookups - how to obtain data from a master spreadsheet into another 5
Excel Excel spreadsheets opening at top instead of bottom. 4
Excel 2003 3
vlookup to copy data from another tab 2
update graphs automatically either from same book or a new spreads 1
Linking 2 spreadsheet using data from 1st spreadsheet 1
Filter by User ID 1
Microsoft Works to Microsoft Office 6

Back
Top