John Carney
asked on
Excel 2007 best practices when linking to an external workbook
I have a workbook in Excel 2007 in which 8 sheets have up to 1800 formulas linking to an external workbook. Since each sheet has the same formulas in the same cells, I could easily set it up so that one sheet links to the external workbook and let the other 7 sheets link to that sheet.
Would that somehow be more of a "best practices" way to do it? Or does it matter either way?
Thanks,
John
Would that somehow be more of a "best practices" way to do it? Or does it matter either way?
Thanks,
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, all of you. I posted a followup question here about how to use XML. Please take a look.
https://www.experts-exchange.com/questions/27312533/Using-XML-to-get-data-from-an-external-workbok.html
https://www.experts-exchange.com/questions/27312533/Using-XML-to-get-data-from-an-external-workbok.html
ASKER
Thnx,
John