?
Solved

Problem when opening write protected Excel sheets.

Posted on 2006-06-09
4
Medium Priority
?
229 Views
Last Modified: 2012-06-21
I have a user that has a strange problem.
Every time he opens a particular Excel document, and it is in use by another user, Excel shows the e-mail header, as if he had pressed Files/Send to.../Mail reciepient.

But if the same document is not in use by someone else when it is opened, the mail header doesn't show up.
So it shows every time the document is opened as write protected.

He tried opening other Excel documents as write protected, and all of them show up normally - without the mail header.

Does anyone know what could be the problem??
0
Comment
Question by:sotea
  • 2
  • 2
4 Comments
 
LVL 44

Accepted Solution

by:
bruintje earned 1500 total points
ID: 16875969
Hi sotea,
----------

the try the following

1. open the file normally under this user
2. Click on the Mail button in the standard toolbar 2 times to have the mail header appear and close
3. Save the file
4. Close Excel
5. now try again to see if that made a difference

be sure to cleanup some tempfiles on the machine or fileserver user folder

it could be that some cached/temporary version or corruption is coming into play when the user is opening the file read only [in use by another user]

----------
bruintje
share what you know, learn what you don't
0
 
LVL 1

Author Comment

by:sotea
ID: 16885560
Hi Bruintje

I'll try your solution, and get back to you with the result...
0
 
LVL 1

Author Comment

by:sotea
ID: 16932664
Hi Bruintje,

The problem solved itself, without my interaction.
But thanks for your suggestions anyway:-)
0
 
LVL 44

Expert Comment

by:bruintje
ID: 16932678
great and thanks :-)
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I came across an unsolved Outlook issue and here is my solution.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question