Public folders

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

Guest

Outlook 2003
We have started up using a public folder to share documents.
We work with Excel workbooks that we store in a public folder.
All the documents in one folder is based on a template, so they are alike.
To generate statistics we have linked some cells from the excel sheets to
fields in the public folder.
My problem is that the content of the cell in excel is often not shown in
the public folder.
Where can I find some guidelines how to define the fields/names in
Outlook/Excel?
Is there somthing I should be aware of?
 
You should use one word, or a combination of words for field names in Excel,
if you are linking to somewhere else. i.e. - no spaces.

firstname not first name

This makes things easier all round.
 
Hi Mako

Thank you for the answer.
I have done that.
I have been told that cells that are to be used in connection with Public
folders should be formatted as TEXT. I have tried to do that but if there are
formulars involved it seems to mess up things.
I can usualy correct the error, but then a few days later the error reapears.

CDL
 
CDL said:
Outlook 2003
We have started up using a public folder to share documents.
Click to expand...

In truth, Outlook is not a file system. You should share documents in a
network with network shares, not with public folders in Outlook. Outlook is
for storing mail messages, calendars, and contacts, not for storing general
files.
 
Hi Brian

Do you know another program that gives you the same overview as the public
folder system in outlook.
I must say that apart from my problems with the missing informations in the
fields the system is perfect for "sharing" excel documents.
It is very easy to retrieve information and make statistics.

Kind regards

CDL
 
What kind of "overview" are you looking for? SharePoint is a much better document management platform. Exchange is missing check-in/check-out features to prevent users from overwriting each other's changes.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Hi Sue

In the Public folder it is possible to define different fields that are
linked to cells in the excel documents. I can then sort the document as I
please and copy the fields back to Excel and make various statistics.
I do not know the Sharepoint program, is it available to everyone as default?
The good thing about the public folders is that you just need to have
Outlook.

Kind regards

Christian
 
SharePoint is a server application, not a client. The problem with using Exchange public folders is that there is no way to prevent one user's changes from otherwriting another's.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


CDL said:
Hi Sue

In the Public folder it is possible to define different fields that are
linked to cells in the excel documents. I can then sort the document as I
please and copy the fields back to Excel and make various statistics.
I do not know the Sharepoint program, is it available to everyone as default?
The good thing about the public folders is that you just need to have
Outlook.

Kind regards

Christian
Click to expand...
 
Hi Sue

I think Sharepoint would be overkill for our needs.
As it is mainly one person working in each document the risk of overwriting
is limited.
I think the Exchange public folders are perfect for our use.
I just need to find out how to secure that the defined fields shows the
content of the cells in the Excell sheet.
Can I find some litterature explaining about the use of Exchange public
folders??
(It does not seem to be a subject covered in your book?)
It seems to be very limited what I can find in the help function in Outlook.

Kind regards

Christian
 
Back
Top