Is there any method of Compacted and Compressed Data Files in Excel or Word.?
D Debra Dalgleish Feb 13, 2004 #2 Excel doesn't have a feature that's equivalent to Compact and Repair in Access. However, you can use the technique outlined on the following page, to reset the used range: http://www.contextures.com/xlfaqApp.html#Unused
Excel doesn't have a feature that's equivalent to Compact and Repair in Access. However, you can use the technique outlined on the following page, to reset the used range: http://www.contextures.com/xlfaqApp.html#Unused
