automatic links to other workbooks
When I receive a excel workbook made by someone else and go to open it, a
yellow box appears that reads" There are automatic links to another workbook. "Do you want to update this workbook with changes made to other work book?" one then clicks "yes" or "no" These are very big workbooks and I want to be able to find what cells have the formula to look up inofrmation form another file. Although I can click and read every cell that contains information (1000's of them) there must be a much easier way. Any suggestions? Thanks |
automatic links to other workbooks
When I can't find links, I'll use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Junkman wrote: When I receive a excel workbook made by someone else and go to open it, a yellow box appears that reads" There are automatic links to another workbook. "Do you want to update this workbook with changes made to other work book?" one then clicks "yes" or "no" These are very big workbooks and I want to be able to find what cells have the formula to look up inofrmation form another file. Although I can click and read every cell that contains information (1000's of them) there must be a much easier way. Any suggestions? Thanks -- Dave Peterson |
automatic links to other workbooks
IT WORKED! thanks "Dave Peterson" wrote: When I can't find links, I'll use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Junkman wrote: When I receive a excel workbook made by someone else and go to open it, a yellow box appears that reads" There are automatic links to another workbook. "Do you want to update this workbook with changes made to other work book?" one then clicks "yes" or "no" These are very big workbooks and I want to be able to find what cells have the formula to look up inofrmation form another file. Although I can click and read every cell that contains information (1000's of them) there must be a much easier way. Any suggestions? Thanks -- Dave Peterson |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com