We need a lot more information about how you bring in the data now, but basically if you are styling inside ID, you should be able to apply either a character or paragraph style to the codes (depending on if they are separate paragraphs or part of a larger paragraph), and simply edit that style to update the entire document.
That said, if you are Placing and linking to the spreadsheet and updating the link each time there is a change, it is more complicated.
Hi Peter, yes in the past I just imported the copy into text boxes, styled them with style sheets and seperated them with normal tabs. Therefore no link to the excel master. I am thinking that doing them in tables would give me some automation benefits, but this would still not create a link to each row. Ideally I would like to have some sort of tag to the order code which will then enable the programme to find the row even if its position in the excel file changes.
Bob does more with Excel import than I, but I believe that to do waht you are asking you need to import named ranges from Excel, and set ID to link to spreadsheets rather than embedding, before you do it. Once the sheet is linked, it can be updated like any other link.
The hitch comes in the styling. Unless you use Table Styles to format the tables, any styling you do in ID will be lost and the Excel styling will be used when the link is updated.
Indeed named ranges are the way to handle it.
Since we're dealing with CS3 here, I think that's okay. There's a bug in CS4 and CS5 with XLSX files where it won't read them. Workaround is to save as XLS.