database wizard rearranging shapes

[Matt]

Hi -

I asked this on the general group a few days ago with no luck, hopefully
somebody here will have an idea.

I have a Visio page that is linked to an Excel spreadsheet using the
database wizard. I rearranged the various db-linked shapes on the page into a
specific format. I want to keep that format even when the data is changed and
refreshed in Visio.

The problem is that if I delete a row in the middle of the spreadsheet, the
shapes that match the rows of data after the deletion all get rearranged and
take the place of the previous table rows data.

For example, say I have these rows of data in my excel spreadsheet:
1
2
3
4

If I delete row 2 in Excel, then reload my Visio page, the shape for row 2
now contains row 3's data, and the shape for row 3 now contains row 4's data.
Row 4's shape has completely disappeared.

Ideally, what I would like is for row 2's shape to disappear from the sheet.

Any ideas about what I am doing wrong, and how I can fix it?

Thanks,
Matt

[Al Edlund]

it sounds like a shape naming type of problem. did you rename the shapes
when you created them to something other than the format of PAGE1.1 etc.
al

Post by Matt
Hi -
I asked this on the general group a few days ago with no luck, hopefully
somebody here will have an idea.
I have a Visio page that is linked to an Excel spreadsheet using the
database wizard. I rearranged the various db-linked shapes on the page into a
specific format. I want to keep that format even when the data is changed and
refreshed in Visio.
The problem is that if I delete a row in the middle of the spreadsheet, the
shapes that match the rows of data after the deletion all get rearranged and
take the place of the previous table rows data.
1
2
3
4
If I delete row 2 in Excel, then reload my Visio page, the shape for row 2
now contains row 3's data, and the shape for row 3 now contains row 4's data.
Row 4's shape has completely disappeared.
Ideally, what I would like is for row 2's shape to disappear from the sheet.
Any ideas about what I am doing wrong, and how I can fix it?
Thanks,
Matt

[Matt]

Al -

I assume you are talking about changing the Name listed in Format|Special.
It doesn't help the problem, if I delete a "middle" record, the previous
records still take its positions. Looking at the name in format special, the
"moved" records will all have the name of the shape they took the place of.

Any other ideas on this?


Thanks,
Matt

Post by Al Edlund
it sounds like a shape naming type of problem. did you rename the shapes
when you created them to something other than the format of PAGE1.1 etc.
al

Post by Matt
Hi -
I asked this on the general group a few days ago with no luck, hopefully
somebody here will have an idea.
I have a Visio page that is linked to an Excel spreadsheet using the
database wizard. I rearranged the various db-linked shapes on the page into a
specific format. I want to keep that format even when the data is changed and
refreshed in Visio.
The problem is that if I delete a row in the middle of the spreadsheet, the
shapes that match the rows of data after the deletion all get rearranged and
take the place of the previous table rows data.
1
2
3
4
If I delete row 2 in Excel, then reload my Visio page, the shape for row 2
now contains row 3's data, and the shape for row 3 now contains row 4's data.
Row 4's shape has completely disappeared.
Ideally, what I would like is for row 2's shape to disappear from the sheet.
Any ideas about what I am doing wrong, and how I can fix it?
Thanks,
Matt