Statement I: The data from the consolidation ranges and target range are saved when you save the worksheet.
Statement II: If you later open a worksheet in which consolidation has been defined, this data will not be available again.
Consider above two statements, identify the correct one.
(a) Statement I is wrong
(b) Statement II is wrong
(c) Both the Statements I and II are wrong
(d) Both the Statements I and II are correct