Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Excel 2007 - Unreadable content when opening files

Hi guys,

I have a user on the netwerk running windows 7 and Excel 2007.
On a lot of files he tries to open from a network location he receives an error 'unreadable content'. He is requested to repair the file; if he does so he looses some layout details etc...
This happens not always... Somethimes he can open the same file without problems by retrying.
The user claims the problem also occurs on files witch he has created himself.

Office and Win7 are up-to-date. Problem remains...

Peter
  #2   Report Post  
Junior Member
 
Posts: 1
Default

There may be a number of causes for this problem.
It is best if the user does not repair the file, as this will ruin all the formatting. Excel file repair process is not well implemented in my opinion. typically the file does not have a problem, the cause is something else

Can you answer these questions:
1. Is it any specific type of file, eg an XLSM (with macros), and XLSX with lots of conditional formats, charts or data validation, an XLS spreadsheet?
2. Do the files contain links to other files, or ODBC links?
3. Have they been opened in Excel 2010 and saved? Sometimes old 2003 and earlier files have a massive increase in styles and formats due to this issue.
4. Is the user opening the files from Windows Explorer by double-clicking or from Excel File Open ?
.

Then try these steps:
1. Check for this ShellStreams DLL You may receive "Unreadable Content" when opening files from within Excel 2007, if you have a shellstreams.dll file
2. First open those files on another machine and see if the problem persists. If not then the problem is isolated to the user's environment.
3. Disable all add-ins and see if the problem recurs. If not, then re-enable add-ins one by one until the offending add-in is found.
Excel Repair Toolbox can save a recovered data into new XLSX files. The heuristic search algorithm allow finding data for any damaged file. Fore more https://www.repairtoolbox.com/excelrepair.html
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel found unreadable content sb07 Excel Discussion (Misc queries) 1 March 4th 10 01:19 PM
Excel found unreadable content Greg Creme Excel Programming 0 December 2nd 09 08:46 PM
Excel found unreadable content Erika Excel Discussion (Misc queries) 0 November 17th 09 08:21 PM
Opening workbook - get error message : unreadable content, lostvbproject [email protected] Excel Programming 4 October 17th 08 03:35 PM
Excel found unreadable content: auto.pilot Excel Discussion (Misc queries) 1 January 19th 08 07:04 PM


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"