Inserting Excel Worksheet

Started by SCADATom, December 24, 2008, 05:00:16 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

SCADATom

When I create an Excel Worksheet and insert it into Visio, sometimes only part of the worksheet is inserted (insert-insert object-excell worksheet-create from file-link to file).
How do I get the entire worksheet that I have created into Visio
(Visio 2002)

wapperdude

What I usually do is the following--assuming you're only doing a single worksheet:
1.  Select all of the cells that you want paste, and then copy.
2.  In Visio, do Paste Special>As Excel worksheet.

This works every time.

I suspect, that with the insert method, you still need to make sure that all of the cells are selected, which I think is down thru print or page setup > print area. 

But, once inserted into Visio, you should also be able to double click to open Excel, grab the left or bottom borders to extend and include the desired columns and rows.  Close Excel.  You may have to resize the Excel object.

These are three methods that ought to work.

HTH
Wapperdude
Visio 2019 Pro