Excel embedded tables not opening

[Andrew_H]

I've started a new job and we do a lot of generated excel tables that we embed (paste special) into visio.  For some reason, I get a disc full message when I try to embed those tables in visio.  They still embed but I get the error message.  Once they're inside visio, they're visible but I am unable to open them up to edit them.  This is the error message I receive: "An error (1415) occurred during the action Open Object. Visio is unable to edit the worksheet object."  I'm able to select the table and them copy and paste the table into excel, once its in excel I can click on the table to open it.  This is elaborate and not the best long term solution.

Has anyone delt with this and knows of a fix?

[Surrogate]

Do you know what version of Excel was used before pasting?
For example, if it was an Excel 2007 book, Visio will specify that it should be opened with that version. When you want to open the embedded Excel book, there will be an error with a more recent version.