Excel sheet to csv file showing large size

[ajoy123rocks]

The below sheet does not contain any data in the cells. The items shown in colours are all objects.

When saving as csv file, it shows about 6gb size and takes too long to save.

Link to file: DSS_Test.xlsm

 

[Artik]

In many sheets, UsedRange indicates an area covering a very large number of rows (almost all the rows of the sheet), even though the data occupies at most a few dozen rows. Hence the large file weight despite the small amount of data. I tried to remove the redundant rows only in the Game_Info sheet. However, UsedRange still indicates a huge area. The conclusion is that the sheet (and perhaps others) may be corrupted. When saving the file as a csv, Excel writes the data from the UsedRange cells to the file.

Artik

 

[Alex Blakenburg]

What sheets are you trying to save as csv ? Is it the 2 scorecard sheets ?
In the workbook you provided both those sheets have row 72 as the first hidden row. If that is that can be relied on and is the same in your real workbook, then on a copy of your workbook run the code below and see if that fixes your issue.

Sub ResetRowHeight()
    Dim sht As Worksheet
    
    With Application
        .EnableEvents = False
        .ScreenUpdating = False
    End With
    
    For Each sht In Worksheets
        With sht
            If Left(.Name, 10) = "Scoresheet" Then
                .Rows("72:1048576").RowHeight = 14.5
                .Rows("72:1048576").RowHeight = 0
            End If
        End With
        
    Next sht

    With Application
        .EnableEvents = True
        .ScreenUpdating = True
    End With
    
End Sub