Just open all the files you reference (as recommended make sure the referenced files are on a networked drive or SharePoint site), and build your formula by clicking on the cell in the file you need. Excel automatically references the file location.
Dec-23-2009 16:18
Boomer187
Spicy Hotdog
Registered: Aug 2001
Location: USA
Re: Re: Re: Adding Cells in Excel across pages".
quote:
Originally posted by Acton
Providing it's Excel 2007, of course.