This video is answer for forums question
[ Ссылка ]

I explain you how to make an automatic resizing of an embedded Excel object: changing the number of rows and columns as well as the size of the cells according to the change in the source Excel book

0:00 Intro
0:30 Embedded Excel object. Visual differences for different versions
0:57 Excel application side
1:21 Excel side. Add named range
1:38 Excel side. Select & copy this range
1:50 Visio side. Paste special with link
2:14 Excel&Visio sides. Synchronous changes

Sorry for my terrible English!!!

свернуть