Share via

"There isn't enough memory to read worksheet" error when tried to open xlsx object from Powerpoint 2010

  • Article

Question

Monday, August 26, 2013 7:31 AM

Hi,

I have a powerpoint presentation (will call it A.PPTX) which has an embedded spreadsheet object (B.XLSX). I was able to double click the object in "A" and open "B.XLSX" as and when necessary.

today, i opened B from the A and inserted another spreadsheet C.XLSX as an object in B. Closed all the files and saved A.PPTX. when i tried double click and tried to open B.XLSX from the powerpoint, i am getting an error "There isn't enough memory to read worksheet"

Unfortunately, i don't have a backup of B.XLSX as I always edited it by opening it from the presentation. is there a way to recover it?

Note: 

1. read through similar threads in the forum about errors while inserting objects or similar error in Powerpoint 2003. the solution provided did not help

All replies (4)

Tuesday, August 27, 2013 3:53 AM âś…Answered | 2 votes

Hi

By the description, you want to recover the embedded worksheet in PowerPoint.

Try following methods:

1.Click to the presentation file

2.Change the file extension from pptx to zip

3.Open the file, locate to ppt>embeddings

4.There you will see the embedded worksheet

5.Save the file to another path and open it

If the worksheet is still corrupted, following these steps to recover an Excel file:

1.Change the file extension from xlsx to zip

2.Open the file, locate to xl>workbook.xml

3. These XML files contain the data of each spreadsheet.

4.Copy the data to a new worksheet and save

Regards

Tylor Wang
TechNet Community Support

Tuesday, December 3, 2013 6:13 AM

Hi,Tylor.

my user have the same error.

Is there any way to repair the embedded worksheet instead to recover it?

in a pptx file,user had embedded out of 10 worksheets,but 3 worhsheets have this errors.

AND why does the error occur?

Thanks!

Friday, February 28, 2014 7:13 AM

Awesome. It worked...!! Thanks for posting this. Really helped.

Friday, July 31, 2015 1:12 PM

I tried this and after attempting to open the XML file,received another error.  "XML file cannot be displayed...cannot view XML using style sheet.  Correct the error and try again".    

I am not sure what style sheet is or now to try to trouble shoot this.   This is a work presentation so I am anxious to get it restored.   Any guidance would be appreciated.

Thanks, 

Laura