Clearing a consolidation

  • Thread starter Thread starter holly
  • Start date Start date
H

holly

Hello, I was just wondering how you completely remove
consolidation on a table of data. I have gone back to the
consolidation dialog box and deleted the references but I
still have the little plus signs to the left of my
worksheet.
Thank you in advance
Holly
 
Holly,

If I understand your question correctly, you have performed Data |
Consolidate. And you have consolidated data on your worksheet?

If you did not choose "Create links to source data" then you should have
values only on your worksheet. You simply have to delete the consolidated
results.

If you chose ""Create links to source data" then you might wish to delete
the references above the consolidated results as well as the formula for the
consolidated data.

I am not sure if I understood your question properly, so let me know if I
zigged when I should have zagged.

Regards,
Kevin
 
Back
Top