Error when pasting Excel Worksheet into Powerpoint as a MS Office Excel Worksheet Obj

[StuartSmith]

I am experiencing an issue when pasting an Excel Worksheet into Powerpoint using Paste Special and choosing the default "Microsoft Office Excel Worksheet Object". After pasting in the worksheet, when you double click on the excel object we receive the message "There isn't enough memory to read Worksheet".

The excel workbook contains filters on a column in several of the worksheets. When the filter is applied I receive the message above. If the filter is not applied, I do not receive this message. All the filters have to be turned off in the workbook.

I wanted to see if anyone has experienced this problem and if there was anyway to get it to work without having to remove the filters.

This is occuring with both Office 2003 and Office 2007 but I am more concerned with 2007 at this point.

I also posted this question here http://www.mrexcel.com/forum/showthr...91#post2466191

[romperstomper]

Hi, and welcome to the forum.

Unfortunately:

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this.

[StuartSmith]

Sorry about that. I wasn't aware. I will limit to one board and repost to this board if I do not get a response on the other board. I will paste the link to the other board if I do that.

[romperstomper]

If you just add a link here, then you may get assistance in both. You also ought to add a link to your post in the other forum (or forums - I've only noticed one so far )

[StuartSmith]

Added link to other post. Only posted on 2 forms. Thanks for letting me know. I have never posted to a forum before.

[samyscheer]

Dear Excel Masters!

I'm still having the same issue as StuartSmith in 2012. I'm running Microsoft Office for Mac 2011 on a MacBook Pro. The problem for me isn't pasting the information from excel to PPT but making sure it is updated whenever I change something in the Excel file. I've tried having PPT or Excel or both open and closed, the error I get is the same as StuartSmith when I want to update the Excel data in PPT by right clicking on it and selecting "edit worksheet object". I inserted the worksheet into excel by "paste special" into powerpoint with the option paste as "microsoft excel worksheet object". My powerpoint is a pptx file, my excel file a xlsx one.

Would really appreciate any help, thanks a million in advance!

[arlu1201]

samyscheer,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.