Pages

Friday, May 12, 2017

How to fix Microsoft is trying to recover your information in Excel

Summary: The blog explains why ‘Microsoft is trying to recover your information in Excel’ dialog box appears, and how it can be resolved. The solution mentioned in the blog helps bring Excel workbooks to the normal mode from all types of corruption.

While attempting to open the Excel worksheet, a dialog box may appear which reads: “Microsoft is trying to recover your information in Excel.” which means there is a probability that the workbook you are trying to access have turned corrupt and require immediate recovery.

The dialog box appears similar to the below image and may differ with different Excel versions:












In case, any damage occurs in the file, the good thing is that Excel will automatically start the File Recovery mode.

Automated File Recovery

Automatic File Recovery mode is an exceptional feature integrated into Microsoft Excel. It allows recovering the corrupt workbook without affecting Excel file. Sometimes, Excel fails to start the File Recovery mode automatically; in that case, the user will be required to open it manually.

To open the built-in recovery utility manually, follow the steps below:
  1. Click on the File menu and then select Open
  2. Navigate through the path where folder with corrupt workbook is stored 
  3. Next, in the Open dialog box, select the corrupt workbook
  4. Then select the arrow sign which appears next to Open button
  5. Click on Repair to recover all recoverable data from the corrupt workbook
The File Recovery feature successfully repairs the damage found in the workbook. If neither manual nor automatic repair work or Excel file issue then, you can try some other manual recovery methods to prevent the lost data. Make sure to take some preventive measures to salvage data against accidental deletion or permanent loss.

Additional Workaround to Rectify Excel Errors
  • When Workbook Opens in Excel
If you encounter ‘Microsoft is trying to recover your information in Excel’, you may still be able to work as normal, but the dialog box will interrupt you in between. If the workbook is open in Excel, revert to the last saved version can help rectifying the problem.
  1. Click on the File menu and then select Open
  2. Now, double-click on the name of the workbook that is open in Excel 
  3. Click on Yes button to reopen the workbook
  4. The workbook will open without any recently made changes that caused the Excel workbook to turn corrupt
  • When Workbook is not Open in Excel
If the workbook has become inaccessible, the following workaround procedure to set the calculation option to manual may rectify the issue. Due to changing the calculation settings to manual, the workbook will not be recalculated, and it may open after that. This may help get rid of the Excel not responding issue. Follow the steps below:
  1. Click on File and then click on New 
  2. Under New option, click on Blank workbook
  3. Then click on File and tap on Options
  4. Under Calculations option in the Formulas category, click on Manual and then OK
  5. Next, click on File and then Open
  6. Locate the workbook and double-click on it to open
Tips & Measures to Prevent Data

The following are a few tips and actions that must be taken into consideration to avoid data loss. Let’s look at each:
  • Auto Save Backup Copy of Workbook
Always remember that you will never run out of data as long as you hold a backup copy of the workbook. Even if the workbook is deleted accidentally or the application itself turns corrupt, you still manage to gain access to incorporated data.
  1. Click on File and then click on Save
  2. Click on Computer and click on the Browse button
  3. In the Save As dialog box that appears, click on the arrow sign next to the Tools and then select General Options
  4. In General Options dialog box, tick the checkbox associated with Always create backup
  • Auto Create Recovery Files at Set Intervals
Recovery of the workbook helps to access the workbook after deletion, inaccessibility, and corruption.
  1. Click on File and then Options
  2. In Excel Options dialog box, click on Save from the left pane
  3. Under Save Workbooks section, check Save AutoRecover information every checkbox and enter the duration of minutes in the box provided. By default, this duration is set to 10 minutes and can be changed 
  4. Next, in AutoRecover file location box, provide the destination path where the saved workbook needs to be saved
  5. Ensure that Disable AutoRecover for this workbook only box is unchecked
The above manual procedures help rectify some errors due to which Excel stops working suddenly. Other than recovering workbooks from minimal and higher intensity corruption, the tool helps turn workbooks to the normal mode from the state of inaccessibility.

Since ‘Microsoft is trying to recover your information in Excel’ dialog box occurs only when there is something wrong with the workbook; it requires resolving the error to stop this dialog box from reappearing. The dialog box normally appears in the state of corruption, so you can try the given manual procedures.

What if No Manual Workaround Procedure Works? 

In case if nothing seems to help and you consistently get the same error, you can download Stellar Phoenix Excel Repair tool to repair data from the corrupt workbook. The tool can be utilized to repair workbook data from all corruption issues.

Conclusion

So, these are the basic solution to fix the "Microsoft is trying to recover your information in Excel" error. If you know more solutions to fix this issue then please share it in the comment section.
READ MORE - How to fix Microsoft is trying to recover your information in Excel

Thursday, February 2, 2017

How to repair QuickBooks file that won't open

QuickBooks is one of the most popular accounting software. The software has amazing features like; Report generation, Invoice creation, budget tracking, etc. These features are customizable according to the user’s need. In a case study, QuickBooks has 80% market share with 29 million small businesses. The software helps to companies to stay organised with a large amount of data. With lots of remarkable features, the software is also prone to corruption. Here, I am going to discuss, how you can repair the QuickBooks company file (.QBW) that will not open. Before proceeding to the solution, you should know the reasons for it.


  • Incorrect method to open the QuickBooks file
  • Other windows are open in within the file
  • Opening the QuickBooks file in the wrong version
  • Issue with the file location, such as access permission for the file
  • Compressed file
  • Incorrect file name and file extension
  • Data damage in the file 

Solutions

  • Update the software: QuickBooks provides the maintenance release to update the software by fixing the issue, adding and enhancing of features, etc. Update your software by the latest update. To check the software version, press F2 from your keyboard. Product information windows will be open. You can also check the latest updates from here.
Follow these steps to update the software
    1. Go to File->Close Company/Logoff. Do it for all company (If you have more than one company).
    2. Now, Right-Click on the QuickBooks desktop icon.
    3. Choose, Run as Administrator.
    4. Now click on Help->Update QuickBooks.
    5. Go to Options tab, select Mark All button and Save.
    6. Go to Update Now tab, click on Reset Update and hit the Get Update button.
    7. After completion of the update, a message will appear on the desktop to close the QuickBooks.
    8. Now open QuickBooks desktop and if, you get the message to install the update then click on Yes.
    9. After that, restart your computer.
  • Check the file properties: Here is the quick way to check the company file properties
    1. Right click on the company file and select Properties.
    2. Check the file type i.e. QBW and the size. The size should be greater than or equal to 7MB.
    3. Under the Advanced tab, verify that Compress and Encrypt options should be unchecked.
    4. Click OK.
  • Rename the Company file: To rename the company file, 
    1. Right-click on file.
    2. Select the Rename option.
    3. Try to give a short name (not more than 3 letters).
    4. Do not change the file extension.
    5. Press Enter to save the file with new name.
    6. If the .tlg file is present then, give it the same name as company file. 
  • Turn-Off the multi-user hosting: Sometimes, multi-user access creates the problem in file opening and shows the error:
Or
To stop this, go to the File menu->Utilities and check for the Stop hosting multi-user access. Follow the instructions of the message prompt.
  • Use rebuild data utility: Whenever you face the situation to rebuild the data then, do it in this manner:
    1. Take the backup of your data file
    2. Verify the data file
    3. Rebuild the data file
Note: If rebuild does not help, you then make sure about the data file location on your local machine. QuickBooks also adamant to locate the data file in C drive. Suppose your data file is present in another drive “D” in your system but it’s shared so, in this case, QuickBooks could have an issue with the rebuild. So, copy your data file into C drive and after completion of the rebuild, move the data file back to its previous location. 
  • Try QuickBooks File Repair Tool: One reason can be data corruption and Stellar Phoenix Recovery for QuickBooks® software repairs the corrupt QuickBooks data file. The software is very simple to use and repairs the QBW created in 2007 to 2017. Read the steps to repair corrupt company file by using this software below:
    1. Download the QuickBooks file recovery software and install it.
    2. There is a Select File button on the interface to select the QBW file. You can also find the file from a particular drive by using Find button. To do so, select the drive from the drop-down list and press the Find button.
    3. After selecting the file, click Scan File button.
    4. Follow the steps to see the preview of company information, Employee information, vendor information, etc.  
    5. To save the file, create a blank qbw file to store the recovered data. 
Conclusion: I get the feeling that; you have so many solutions to fix this problem. I also think that some silly mistakes are also the reason of this issue and you should be aware of them. Always take the backup because it is very helpful in troublesome cases.
The good news is that, if all manual methods fail to fix the problem then you have a QuickBooks repair software, which is safe and secure.
READ MORE - How to repair QuickBooks file that won't open

Wednesday, January 18, 2017

How to fix the Microsoft PowerPoint error “The file is corrupted and cannot be opened”

Microsoft PowerPoint is a powerful software developed by Microsoft. It is a very important part of the Microsoft Office suite. People use it to represent the information through slides. You can add several multimedia files like photo, audio, video into it to make it more impressive. Sometimes, you try to open your important PowerPoint file and you got below error message.


You can try below five methods to fix this error message:

Method#1 Open and Repair


  • Open Microsoft PowerPoint
  • Go to File tab and click on the Open
  • Select the corrupted PPT file
  • Select the Open and Repair option from the drop down menu.

Method#2 Component Security Setting

To set the component security setting, follow these steps:

  • Start RUN, enter dcomcnfg and press the OK button.



  • Expand Component Services->Computers. Now right click on My Computer and select the Properties.

  • Choose the Default Properties tab and set the following:

Default Authentication level: Connect
Default Impersonation level: Identify


  • Click OK and then Yes.
  • Open MS PowerPoint again and open the corrupted file.

Method#3 Check the Trust Center Setting

Quickly check the trust center by the following steps:

  • Open MS PowerPoint
  • Go to File tab and select Options
  • Select the Trust Center and press the Trust Center Settings button as shown in the figure.
  • Now select the protected view option, disable the first option “Enable Protected View for files originating from the internet”, and click on OK.


 Method#4 Insert slide into blank presentation

  • Create a blank presentation
  • Go to the Home tab and check the New Slide option
  • Click on the Reuse Slides option
  • Now select the slide of corrupted presentation from Browse option.

After doing this, all slides except the slide master will insert into the new presentation.

Method#5 Save the presentation in RTF

By this way, you can recover at least the important content from the presentation.

  • Open the presentation, then choose Save As option
  • Save the RTF from Save File As Type
  • Choose the file name and location for it and save it

Methods#6 Stellar Phoenix PowerPoint Repair Tool

  • Download Stellar Phoenix PowerPoint Repair tool and install it.


  •  Select the corrupted PowerPoint file. The software supports PPT, PPTX and PPTM files.


  • Press the Scan button to start the scanning process. 


  • After completion of the repairing process, you can see the preview of your corrupted file



  • Save the repaired file. 

Conclusion: These are the best solutions to repair corrupt PowerPoint file. It is a suggested to make a copy of your corrupted presentation and try the repairing methods on it. If you know more methods to fix this problem then please share with me.
READ MORE - How to fix the Microsoft PowerPoint error “The file is corrupted and cannot be opened”
Related Posts Plugin for WordPress, Blogger...