News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Modify excel table

Started by gyd, November 17, 2023, 01:27:23 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

gyd

Hi all

I'm struggling with something that should be a no brainer in my opinion.
I embedded an excel worksheet in my Visio drawing. Insert -> Object -> MS Excel Worksheet with the option "create new" (i.e. not using an existing excel file).
Now I can define my table as I want, filling in information in the cells I need. Once I'm done that's perfectly shown in Visio.
And here comes the problem:
when I open the worksheet again (by doubleclicking), it opens the worksheet in Excel. I can edit all information. OK so far.
Now when I add a row or a line, no matter if on the beginning, middle or end -> the last line/row goes lost, is no more displayed.

This does not happen when I embedd an existing file. In this case, I might have to close/open Visio then I do major changes to the linked file, but it always takes every changes into account.
But what I don't like with additional files is that you'll always have it to stick around with your Visio file...

Any solution for this? Is it just me?

Cheers
Dom

wapperdude

With the Excel object open, hover the mouse over the center of either the bottom or right edges, the pointer will change to a double headed arrow, press left mouse button and drag to resize.  You can either grow or shrink the worksheet.

Visio 2019 Pro

Browser ID: smf (is_webkit)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 157 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1053KB.
Tokens: post-login.
Cache hits: 13: 0.00215s for 26,766 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]