As the chief accountant of a firm, your daily activities encompass dealing in big transactions and figures that essentially need to be saved and securely stored in the spreadsheets and workbooks. Thus it’s MS Excel all the way and it’s this particular feature of MS Office that always remains open on your laptop screen.
Rampant use of a particular feature may result the screen to freeze for a stipulated period of time but if you are among those whose spread sheets give out the error message “Unable to read file” while opening and then it is customarily followed by a grey screen, you need to review the situation carefully. When you open it in quick view, you see that the file exists but you are unable to access it. The said error can get reflected in varied ways though the factors instigating it and the manifestations might differ.
Another situation that can prompt the display of the same error goes like this:-
You open an excel file that you have been working on for weeks now and a window message stating, “The workbook you are opening contains macros. Some macros may contain viruses,” flashes on the screen offering you a choice to choose from three buttons that says Disable Macros (default), Enable Macros, & Do Not Open. You are amazed to see this as you get a periodic virus scan done every month and you are dead sure that the concerned file does not have macros. You are further confirmed when you check the Macro menus after opening the file and find no macros but immediately after the macro message you are bombarded with another shock in quick succession “Unable to Read File”. When you try viewing the data by opening the file using the text editor you see that its still there.
If you are encountering a similar problem, do not loose hope because there are times when simple yet beneficial troubleshooting mechanisms set similar complications.
Provided below are a few of them.
• Norton Anti- virus sometimes conflicts with Excel and creates these faults. The workaround available is uninstalling Norton, uninstalling Office, rebooting and reinstalling Office.
• Sometimes add-ins hinders proper functioning in Excel. Disable them to gauge the difference.
• Remove office then remove \program files\ ms office. You will be required to remove excel from the registry file. If you are not an old hand at it, do not try this as it necessitates backing up the registry first and then restoring it in case there are discrepancies while operating the Registry Editor. This might involve reinstalling the operating system and Microsoft support cannot provide any comprehensive solution if your registry is handled incorrectly.
• Sometimes the files with an .xlb extension that Excel uses to store toolbar information turns corrupt and gives rise to similar complexities. Delete all
the .xlb files you can find to see if it makes any difference but you are liable to lose any toolbar customization that you might have made in Excel.
If these troubleshooting mechanisms work, nothing like it but if it doesn’t better arrange for a backup. You won’t have to search longer cause you have help at hand.
Stellar Information Systems Ltd, a market leader in data recovery and service solutions has come up with a quick fix to troubleshoot this problem with outstanding results.
Stellar’s indigenously devised powerful and robust software Stellar Phoenix Excel Recovery is an advanced Excel spreadsheet repair program, which effectively repairs, recovers and restores corrupt Microsoft Excel files even when they are heavily damaged. The corrupt file is opened and data recovery tools are employed for extracting data from it.
It’s uniqueness lies in the fact that it performs a through scan of the entire Excel spreadsheet to extract as much data as possible without deleting or modifying any of its original content. The powerful algorithms that back this software enable a comprehensive data retrieval from the spreadsheets by preserving the format of the spreadsheet with all its features intact.
The software supports all the modern file versions of Microsoft Excel including Excel 2007, Excel 2003, Excel XP & Excel 2000 and is compatible with Windows NT, 2000, 2003, XP AND Vista.
