?
Solved

Excel File-Office 2007

Posted on 2011-02-17
3
Medium Priority
?
280 Views
Last Modified: 2012-05-11
Excel opens by itself and other Excel files as designed with the exception of one shared network file.
Other users can open the file at will, displaying the contained data.
The problem is with one user/system. User attempts to open the file and there is no data. No error messages, etc.
Copying the file to the local drive and opening it have the same results as opening from the network drive. The file opens, no errors but no data.

I have deleted the Temp and Recent files.
I have uninstalled/reinstalled Office.
I was going to delete the book.xlt file but this user does not have one.


XPSP3 Office 2007
0
Comment
Question by:David-Howard
  • 2
3 Comments
 
LVL 6

Expert Comment

by:akajohn
ID: 34918261
When you copy the file across to the local drive, did the size of the file change ?
A>
0
 
LVL 27

Accepted Solution

by:
David-Howard earned 0 total points
ID: 34918486
I resolved the issue. The file was marked as open/Temp for her last session on the server. I opened the file and then unchecked "Safe mode" under the Active X Settings from within Trust Center.
0
 
LVL 27

Author Closing Comment

by:David-Howard
ID: 34949737
I resolved the issue. The file was marked as open/Temp for her last session on the server. I opened the file and then unchecked "Safe mode" under the Active X Settings from within Trust Center.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

This is an article on how to answer questions, earn points and become an expert.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

601 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