An Excel Question.....

[natedeia]

I need to find a place that goes into detail on Excel stuff. I am needing to create an Excel spreadsheet and put it on our server. Then on our desktops put a copy of it and link it to the one on the server so that it can gather info from the ones on the desktop. I have taken a class on Office 2000 and know a bit but not enough.

Do you know how?
or a place that tutorials that goes into detail?
Thanks in advance!!!!!

 

[Dreamboat]

Create the Excel spreadsheet.
Hit Tools-Share workbook and click "allow changes by..."
Save it onto or copy it to your network server.
Using Windows Explorer, right-click the file's name and hit create shortcut.
It will place the new shortcut in the same folder on the server.
Click once on the new shortcut and cut it (ctrl-x). Right-click your desktop and hit paste (ctrl-v).
Now, send an email to your coworkers who will be using it and attach the SHORTCUT from your desktop to the email.
Send the email with instructions for them to save the attachment to their desktop.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[Dreamboat]

PS: You need to make sure that everyone who will be using the workbook has proper network access (check with the network administrator) to the location where you place the workbook.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[natedeia]

Thank you very much Dreamboat. Is there a way that I can have a seperate spreadsheet in Excel that is different from the one on the server that can be put on the desktops then when updated then automatically updates the one on the server. Just incase someone screws up, then wont actually screw up the one on the server. I am guessing I should use Access. What do you think? I just need a few fields populated. Thanks again!

 

[Dreamboat]

No problem, but you need to copy the cells from the single worksheets into the main worksheet by Edit-Paste special-Paste links. Then, the main workbook will be updated when you open it...

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com