Consolidating data - removing consolidation

K

Kathrine J Wathne

I have consolidated data from 3 sheets - and the sum is shown in the forth
sheet. I have also created a link to the source data.

Now I want to remove the consolidation again - but I just can´t seem to
remove this from the 4th sheet. How can I remove the consolidation and get
back to normal??

Kathrine, Stavanger, Norway
 
G

Guest

Kathrine, if I understand it, after consolidating three sheets into a fourth,
you want to remove the links. If this is correct, you could select all the
data in the fourth sheet and copy, paste special, values to change the link
formulas to data. HTH
 

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

Worksheet Consolidation 2
Worksheet Consolidation - Repost requested 3
Consolidation of sheets 3
Excel 2007 - Consolidation question 4
Consolidating worksheets 1
Formula within filename link 2
Need macro to consolidate all sheets in workbook 1
Data Consolidation 1

Top