Solved

Excel File-Office 2007

Posted on 2011-02-17
3
263 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

829 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