It might help to create and use named ranges in Excel.
I gave that a try but it made no difference.
I also tried creating a worksheet for each image and linking one text box to the cells. It works fine upon input, but screws up if you make a change in Excel. It seems that when you choose "fix links automatically" that it defaults to the first worksheet and cells. It loses the original targets.
Is this a bug?
When using linked text and excel documents you loose all formating when updating.
1 person found this helpful
It's not simple. Anne-Marie Concepçion has a blog post and video that explains how to do it using table styles.
I rarely have to do this but back in the day when I did, I always found it
easier to do all the formatting in Excel and then link the spreadsheet using
file > place and choosing the formatted table option.
It's not the formatting I'm having problems with (yet). It's the content. I create several text boxes, choose one, File/Place and select a specific cell of the worksheet. I then choose another of the created text boxes, File/Place and select a different cell. Repeat until all imports are complete. Everything has worked fine up to this point. Each box only contains the specified cell. I close the ID document. I open the Excel sheet and edit only one specific cell, close the sheet, and open the ID document. It asks if I want to fix the links, I choose "Fix Automatically". It then updates each and every text box with the entire worksheet, it no longer contains just the specified cell any more. It behaves this way no matter how I update the links.
Sandee - thanks for the link, while it doesn't cover my problem it was helpful.
I finally got it to work! I don't understand the difference, but at least it seems to work.
Originally I set up a blank page that contained 4 graphic boxes and 12 text boxes. I would then select a text box, use File/Place, and select the spreadsheet cell I wanted it to show. Using this method and updating any cell would cause each and every text box to change to the entire worksheet, not just the previously specified cell.
I deleted all the text boxes so the document only contained the 4 graphic boxes. I chose File/Place, select the cell, and draw out the box. I did this for all the cells I wanted. Now when I edit the spreadsheet only the cells change that I edited and it doesn't have the entire worksheet. The funny thing is that it shows all the links need updating, but it only changes the ones changed in the spreadsheet. I can live with that.
I don' know why it wouldn't work by placing the text box first, but it doesn't. Anyway, I got it to work.