156k views
5 votes
What are linked workbooks & how are they different from consolidation worksheets?

User Tfv
by
7.1k points

1 Answer

6 votes
Linking is the process of using references to cells in external workbooks to get data into your worksheet. Consolidation combines or summarizes information from two or more worksheets (which can be in multiple workbooks).
User Lucasls
by
7.4k points