Public Folder link to Excel File

[BigBro]

Hi -

I have a user that claims that he had a shortcut to a spreadsheet "in
his public folders" at his old job. Obviously, he's an end user that
may or may not know what he's talking about.... I'm trying to figure
out the best way to accomodate him.

He basically wants an Excel file stored on a shared folder to be
available to all user as either a shortcut, or a link in the public
folders (can't post to a folder as he will be updating the sheet
regularly). When a user clicks on the shortcut/link, it would just
launch Excel and display the file.

Anybody have any ideas on the best way to accomplish this?

 

[Sue Mosher [MVP]]

You could try this:

1) Create a shortcut on the Desktop to the Excel file on a network volume,
using a UNC mapping.

2) Drag that shortcut into the public folder.

Or:

1) Create a new post item in the folder.

2a) In the body of the item, insert the file, choosing to insert as a link.

Or:

2b) Insert a hyperlink into the body of the item using the
file://\\servername\sharename\filename.xls syntax.

 

[abid]

can anyone tell how to update automatically an excel sheet in public folder.
i have created a public folder and posted an excel file on it. now whenever
i make any change in the exel file, it doesn't update the file in public
folder
need help and reply on (e-mail address removed)

 

[Sue Mosher [MVP]]

Abid, this has already been covered in this thread: You need to post a link
in the folder, not the file itself. I gave three different methods for doing
that. Pick the one that suits your scenario best.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Diane Poremsky [MVP]]

if the excel sheet is opened, edited and saved while the public folder
remains open it should update (works here every time). if you open it,
change folders and fiddle around then save it, it will not update the
version in the folder.

The safest way is to post a link to the folder and edit the file stored
elsewhere - as long as the users saves the file it is guaranteed to be
updated.

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Let's Really Fix Outlook 2010
http://forums.slipstick.com/forumdisplay.php?f=34