Copy & Pasting large data tables into MathCad

[ptc-6721944]

Hi all,

I have built a calculation sheet that is dependent on some rather large data tables. I have used the Insert > File Input method to reference these tables. This works fine for building the sheet, but once I distribute it to 100+ engineers, I feel like there will be an issue with having to lug around several data tables.

I found a semi-solution on here that mentioned defining a variable, and copy-pasting the table there. However, this makes the data tables cumbersome. It's also messing up my vlookups.

Is there a way I can integrate these tables into mathcad the same way one would with a insert > file input method, but without having to become dependent on external files? Perhaps there is a way I can integrate the data directly into my mathcad sheet?

Thank you.

-jw

[Werner_E]

Justin Wollmann wrote:

Hi all,

I have built a calculation sheet that is dependent on some rather large data tables. I have used the Insert > File Input method to reference these tables.

There is no Insert > File Input menu item in Mathcad!?

Is there a way I can integrate these tables into mathcad the same way one would with a insert > file input method,

Again, what are you talking about here?

, but without having to become dependent on external files? Perhaps there is a way I can integrate the data directly into my mathcad sheet?

What else, if you don't want to become dependent on externa files?

If the data is in Excel format you may embed the data using the Excel component.

Otherwise just use Insert > Data > Table and copy and paste the data in the empty table. This would also have the advantage that no installed Excel is necessary to deal with the data.

[RichardJ · Accepted solution]

"Insert", "Data", "Table". Right click on the top left cell, "Paste table".

[ptc-6721944]

Richard, Thank you. This worked exactly as needed. I feel silly now that I did not figure this out earlier.

[MikeArmstrong]

Don't feel silly that you got your answer as I still don't understand the question as you never specified how the data was created in the first instance.