Removing Data Consolidation

AishaKausar

New Member
Joined
Oct 10, 2011
Messages
4
Hi,

Quick question - I was using the Consolidation function in my excel sheets, and was wondering is there a way I can remove consolidation from a sheet. Normal totals are easy to remove, as I can just delete them, however consolidation with links cant just be deleted.

Would really appreciate an answer :)

Thanks a ton! Aisha
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,099,461
Messages
5,468,781
Members
406,608
Latest member
G3TEN

This Week's Hot Topics

Top