software

When I receive a excel workbook made by someone else and go to open it, a
yellow box appears that readsquot; There are automatic links to another workbook.
quot;Do you want to update this workbook with changes made to other work book?quot;
one then clicks quot;yesquot; or quot;noquot;
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
When I can't find links, I'll use Bill Manville's FindLink program:
www.oaltd.co.uk/MVP/Default.htm

Junkman wrote:
gt;
gt; When I receive a excel workbook made by someone else and go to open it, a
gt; yellow box appears that readsquot; There are automatic links to another workbook.
gt; quot;Do you want to update this workbook with changes made to other work book?quot;
gt; one then clicks quot;yesquot; or quot;noquot;
gt; These are very big workbooks and I want to be able to find what cells have
gt; the formula to look up inofrmation form another file. Although I can click
gt; and read every cell that contains information (1000's of them) there must be
gt; a much easier way. Any suggestions?
gt; Thanks

--

Dave Peterson


IT WORKED!
thanks
quot;Dave Petersonquot; wrote:

gt;
gt; When I can't find links, I'll use Bill Manville's FindLink program:
gt; www.oaltd.co.uk/MVP/Default.htm
gt;
gt; Junkman wrote:
gt; gt;
gt; gt; When I receive a excel workbook made by someone else and go to open it, a
gt; gt; yellow box appears that readsquot; There are automatic links to another workbook.
gt; gt; quot;Do you want to update this workbook with changes made to other work book?quot;
gt; gt; one then clicks quot;yesquot; or quot;noquot;
gt; gt; These are very big workbooks and I want to be able to find what cells have
gt; gt; the formula to look up inofrmation form another file. Although I can click
gt; gt; and read every cell that contains information (1000's of them) there must be
gt; gt; a much easier way. Any suggestions?
gt; gt; Thanks
gt;
gt; --
gt;
gt; Dave Peterson
gt;