Excel workbooks internet links...

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I'm not sure where to post this to get the answer I'm looking for....
Problem: I have offices statewide who keep individual Excel Workbooks with
multiple sheets relating to individual clients... they also keep a progress
sheet which is updated automatically as they update individual client
files... this happens within the one workbook that is open at the time....
presently I have to get them to individually email me the sheet or workbook
to look at it centrally. This seems inefficient as I would like to be able
to look at the data for all offices at any time.

Can someone give me some ideas as to how this can be accomplished?


Re: Excel workbooks internet links...

plato wrote

Quoted text here. Click to load it

Don't you have a network?  Then everyone could access a master workbook.

Charles Sweeney

Re: Excel workbooks internet links...

Quoted text here. Click to load it

Sounds like you need a web application instead of Excel.

Stan McCann "Uncle Pirate" http://stanmccann.us/pirate.html
Webmaster/Computer Center Manager, NMSU at Alamogordo
Webmaster, ABATE of NM;  AMA#758681; COBB
'94 1500 Vulcan (now wrecked) :( http://motorcyclefun.org/Dcp_2068c.jpg
A zest for living must include a willingness to die. - R.A. Heinlein

Re: Excel workbooks internet links...

Fleeing from the madness of the  jungle
and said:

Quoted text here. Click to load it

oh my my - the joys of distributed data.

How up-to-date do you need?  week, day, real-time?

Makes a difference to the options.  Also, the closer you get to real time,  
the more impact any new system will have on current practice.

William Tasso


Site Timeline