Author Topic: Linking Shape Data to a SINGLE cell in Excel  (Read 8001 times)

0 Members and 1 Guest are viewing this topic.

music_al

  • Newbie
  • *
  • Posts: 7
Linking Shape Data to a SINGLE cell in Excel
« on: April 29, 2008, 07:14:37 AM »
I have an excel spreadsheet with a column for of numeric values. On a different sheet, I have a single named cell that has the TOTAL of all these cells in it. I want to link that single cell to a shape data graphic and have it update automatically.

I can import the data but as it goes to refresh, it refreshes in the imported data window, but not in the shape itself.

Does anyone know what I am doing wrong ?


Many thanks

Allan

Lars-Erik

  • Sr. Member
  • ****
  • Posts: 278
Re: Linking Shape Data to a SINGLE cell in Excel
« Reply #1 on: April 29, 2008, 08:52:33 AM »
Mmm I tried to reproduce you error...
It told me:  "The following shapes are linked to rows from the source that have been deleted"
A rough translation...

The link is broken (no more chain in the data window), is this the case with you?

Relinking the data updates the shape, which obviously isn't a fix...

.... There! i got it :D

When attaching your excel sheet, after selecting the 2nd sheet.
Try this, select the "Rows in my data have no unique identifier. Use the order of rows to keep track of changes"
Again I'm translating so it might be phrased differently, see the enclosed attachment...

Let us know if this helped...

- Lars-Erik