cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to edit excel table parameters?

Regular Member

How to edit excel table parameters?

I have embedded excel table with data and I export them to matrix of  variables (vectors) and I don't know how to open an editing window to assign rows/collumns of table to these vectors?

I also had this issue in the past. It sometimes appeared and I right clicked the table and I have chosen properties option. But now I can not get it.

I hope someone faced the same situation and knows solution.

Thanks in advance for any help.

6 REPLIES 6

Re: How to edit excel table parameters?

Hi,

 

Which version are you using, Mathcad 15, or one of the Prime releases?

 

How did you set up the excel table?

 

Cheers

Terry

Re: How to edit excel table parameters?

Hi,

I use Mathcad 15.

It happens when I want to edit somebody's document. When I do it from scratch it works normally but I want to edit already created table I have no access to those option.

My colleague from work found the way for it by copying it to new document and it works in  new one and then bring it back to original document.

But I am looking for the way to do it without all those tricks.

 

Re: How to edit excel table parameters?

Can you attach the sheet?
That way people helping you can have a look.
If you're not allowed (to prevent IP disclosure) to attach, create a simple sheet with the same problem.

Re: How to edit excel table parameters?

I can not attach original document but if I copy this part which has issue into new document then will start work and an issue disappear and it will be the same if I create new document this issue will not apear.

The problem happens as I mentioned if I try to edit someone's or my old document.

Re: How to edit excel table parameters?

You cannot attach due to IP reasons? What if you strip out the sensitive parts and save the result as a new document and attach that.

You refer to 'old document'... Was it done in a previous version of Mathcad? If yes, which version?

 

Luc

Re: How to edit excel table parameters?

I think I know the answer for my question. I have checked this issue on computer with Windows 7 and older version of Excel and it works fine. That means that latest version of Ms Office, especially Excel causes this issue.

I also face other issues like lack of ram memory causing long wait to open any table in Mathcad, sometimes up to a minute. I presume that Mathcad 15 badly cooperates with the latest version of Excel.