Thread: Workbook inflated to 6 MB by "x14ac:dyDescent" tags
View Single Post
 
Old 02-05-2018, 11:20 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I will try once more to describe exactly the steps i do on the file you uploaded in #3

1. Remove the object in A1:V2 and set column width for A:Y to 8.43
2. Press the square in the upper left corner above 1 and to the left of A to select the entire sheet.
3. Press Format, Hide & Unhide, Unhide Rows
4. Press Format Hide & Unhide, Unhide Columns
5. Press A to select column A.
6. Right click the mouse and press Delete
7. Press 1 to select whole row 1
8. Right click the mouse and press Delete
9. Save the file.

After I do these steps the file size is reduced to 57 kb and last cell is A1.

Ensure that now you are able to go to A1048576 by writing A1048576 in the Name field and press Enter. Do similarly to confirm that you can go to XFD1.

Can't you reproduce this?
Reply With Quote