please explain the difference between linking data from separate .

  • Thread starter Thread starter Lswb
  • Start date Start date
L

Lswb

could you please explain the difference between linking data from separate
workbooks, and consolidating data.
 
Linking data will give you a dynamic link so that each time you change a
value in the other spreadsheet the linked spreadhseet will also update.

When you consolidate data the values are pasted without formulas so that
even though you change the values on the original sheet they won't change on
the new one, until you re-consolidate.

Also consolidating is a little easier to select the data, rather than
creating formulas.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking many workbooks 6
Trace links between worksheets within one workbook 4
Formula within filename link 2
Links - Please help 7
Copy cells from 4 w'sheets in multiple w'books to 1 w'sheet in 1 w'book 0
pivot tables 2
Import data from several excel files into one file 2
Links 3

Back
Top