I've searched the forum, but cannot seem to find information on this particular issue (although I'd think it has probably been covered somewhere)
I'm a financial analyst. During budget season we have a huge web of spreadsheets that are all linked to eachother. I have several spreadsheets that I'm responsible for with links to the spreadsheets of several other analysts.
My problem is that when I open my spreadsheets, I can choose to update the links, but with many sheets and hundreds of links it's darn near impossible for me to tell what, or if, anything has changed. I'd like somehow to be able to either highlight (or list) the cells who's values have changed due to the update.
Any ideas?
Thanks so much for your help!!
Sam
I'm a financial analyst. During budget season we have a huge web of spreadsheets that are all linked to eachother. I have several spreadsheets that I'm responsible for with links to the spreadsheets of several other analysts.
My problem is that when I open my spreadsheets, I can choose to update the links, but with many sheets and hundreds of links it's darn near impossible for me to tell what, or if, anything has changed. I'd like somehow to be able to either highlight (or list) the cells who's values have changed due to the update.
Any ideas?
Thanks so much for your help!!
Sam