Styjun

Is a hash a zero-knowledge proof?

Order by does not work as I expect

Is there any practical advantage to a parabolic reflector over a high-gain beam antenna?

What is the difference between a game ban and a VAC ban in Steam?

Can a non-EU citizen travel freely within the Schengen area without passport?

'chmod' would set file permission to 000 no matter what permission I try to set

Change TeXForm of ArcTan

Why does the UK have more political parties than the US?

Why would Lupin kill Pettigrew?

What is the difference between nullifying your vote and not going to vote at all?

Looking for an old image of designing a cpu with plan laid out / being edited on a literal floor

How to properly maintain eye contact with people that have distinctive facial features?

What does War Machine's "Canopy! Canopy!" line mean in "Avengers: Endgame"?

How can a single Member of the House block a Congressional bill?

The term for the person/group a political party aligns themselves with to appear concerned about the general public

Is the capacitor drawn or wired wrongly?

Can a helicopter mask itself from Radar?

Strange math syntax in old basic listing

Where can I find the list of all tendons in the human body?

Why use water tanks from a retired Space Shuttle?

Humans meet a distant alien species. How do they standardize? - Units of Measure

What does it mean by "d-ism of Leibniz" and "dotage of Newton" in simple English?

Term for checking piece whose opponent daren't capture it

Are there regional foods in Westeros?

Completely Clear Workbook has 5 MB Size

Is it possible to force Excel recognize UTF-8 CSV files automatically?R Download.File Issue with Excel WorkbookUse a reference from one workbook in a formula of a different workbookExcel formula to reference cells in another (closed) workbook with dynamic file pathSum function for unformat text cells to have finally size in gbVBA Hyperlink to MuiltsheetsExcel Workbook Linked to Another Workbook with a Changing Nameread_excel() yields an error when trying to load one fileEnable macro on a single workbookHow to group and color code data based on two columns in Excel

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

0

I have completely Clear Excel File. it has 5 MB size I can't find a problem. I have the same problem with a work-related file.

https://ufile.io/xsvqd

On the link, you can download the file.

excel excel-formula

share|improve this question

asked Mar 24 at 10:32

giorgi lomidzegiorgi lomidze

107

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  One method which I sometimes follow is to post working range on Text Editor Note Tab Light and delete the sheet and then transfer back data to Excel from Note Tab on a new sheet. Other method I follow is to copy desired data Range to New Worksheet and delete the old sheet. Your link to file download is not working otherwise I could have checked the reason for it.
  
  – skkakkar
  Mar 24 at 10:45
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Following methods can help Directly reduce file size 1. Remove “blank space” in your sheets 2. Check for and delete unnecessary hidden sheets 3. Save your files in binary format (.xlsb) 4. Remove formatting on raw data 5. Double check Conditional Formatting ranges
  
  – skkakkar
  Mar 24 at 10:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  We Have tried that via Note++ and far manager but no use. w have deleted and cleared it via VBA too. I can use other upload or email whatever is convenient for you. here is another link. s000.tinyupload.com/?file_id=04524784539993163581
  
  – giorgi lomidze
  Mar 24 at 11:01
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  in woorkshit iam talkgin about there is no data there is no formating, no values. nothing. its completely clear
  
  – giorgi lomidze
  Mar 24 at 11:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I saved file as DOS Txt file then reopened in Excel as Tab delimited text file which I saved Excel File giving a sie of just 10 KB.
  
  – skkakkar
  Mar 24 at 11:14
  

  
  
  
  

 | 
show 2 more comments

0

0

I have completely Clear Excel File. it has 5 MB size I can't find a problem. I have the same problem with a work-related file.

https://ufile.io/xsvqd

On the link, you can download the file.

excel excel-formula

share|improve this question

asked Mar 24 at 10:32

giorgi lomidzegiorgi lomidze

107

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  One method which I sometimes follow is to post working range on Text Editor Note Tab Light and delete the sheet and then transfer back data to Excel from Note Tab on a new sheet. Other method I follow is to copy desired data Range to New Worksheet and delete the old sheet. Your link to file download is not working otherwise I could have checked the reason for it.
  
  – skkakkar
  Mar 24 at 10:45
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Following methods can help Directly reduce file size 1. Remove “blank space” in your sheets 2. Check for and delete unnecessary hidden sheets 3. Save your files in binary format (.xlsb) 4. Remove formatting on raw data 5. Double check Conditional Formatting ranges
  
  – skkakkar
  Mar 24 at 10:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  We Have tried that via Note++ and far manager but no use. w have deleted and cleared it via VBA too. I can use other upload or email whatever is convenient for you. here is another link. s000.tinyupload.com/?file_id=04524784539993163581
  
  – giorgi lomidze
  Mar 24 at 11:01
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  in woorkshit iam talkgin about there is no data there is no formating, no values. nothing. its completely clear
  
  – giorgi lomidze
  Mar 24 at 11:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I saved file as DOS Txt file then reopened in Excel as Tab delimited text file which I saved Excel File giving a sie of just 10 KB.
  
  – skkakkar
  Mar 24 at 11:14
  

  
  
  
  

 | 
show 2 more comments

I have completely Clear Excel File. it has 5 MB size I can't find a problem. I have the same problem with a work-related file.

https://ufile.io/xsvqd

On the link, you can download the file.

excel excel-formula

share|improve this question

asked Mar 24 at 10:32

giorgi lomidzegiorgi lomidze

107

share|improve this question

asked Mar 24 at 10:32

giorgi lomidzegiorgi lomidze

107

share|improve this question

asked Mar 24 at 10:32

giorgi lomidzegiorgi lomidze

107

asked Mar 24 at 10:32

giorgi lomidzegiorgi lomidze

107

asked Mar 24 at 10:32

giorgi lomidzegiorgi lomidze

107

5 Answers
5

active

oldest

votes

0

Is not empty. The worksheets contain information about previous data (like cell formats etc..). You can clearly see it in the below screenshots.

Worksheet with information, excel allows you to draw to last existing row/column with information:

Worksheet with no information:

A way to remove the data could be with VBA, for example this one: Why does my excel document have 960,000 empty rows?

share|improve this answer

answered Mar 24 at 11:06

WizhiWizhi

3,45421131

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  1) There is no data, 2) There is no Data Validation 3) There is no Conditional Formatting 4) No comments 5) all cell, rows, columns I have deleted via "clear all", via VBA, via "delete rows", via delete columns, via ctrl+a and "delete".
  
  – giorgi lomidze
  Mar 24 at 11:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So if you go to cell A1 and hit Ctrl + End ... it doesn’t send you to some cell down the page?
  
  – Skin
  Mar 24 at 11:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeah weird, I deleted both sheets and added a fresh one and it was still over 200kb's. A brand new workbook was 8kb's. Fun ...!
  
  – Skin
  Mar 24 at 11:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes, that is very weird. some steps helped in but not the exact problem has not been identified.
  
  – giorgi lomidze
  Mar 24 at 12:02
  

  
  
  
  

add a comment | 

0

You do a test . If you shift Control plus End you will reach to Row No. 1048576 but If you take a new work book and fill range "A1:J15" you will reach Cell "J15" . This shows the effect of previous data and formats, auto filters.

share|improve this answer

answered Mar 24 at 11:28

skkakkarskkakkar

2,3132924

add a comment | 

0

If you use ctrl+end on Info worksheet the you get to E1048576. If you tap ctrl+end on the RC-C worksheet you go to XFD1048576.

Info worksheet

Select all rows 1:1048576 on Info worksheet and set for standard height of 14.3.

Use ctrl+home then ctrl+shift+end to grab the used range.

Use Home, Edit, Clear, Clear All the selection.

Save workbook.

Result file size: 2.9Mb.

RC-C worksheet

Select all rows 1:1048576 on RC-C worksheet and set for standard height of 14.3.

Use ctrl+home then ctrl+shift+end to grab the used range.

Use Home, Edit, Clear, Clear All the selection.

Save workbook.

Result file size: 233kb.

share|improve this answer

answered Mar 24 at 11:30

user11246173

add a comment | 

0

If only on sheet had data:

1. Press the arrow indicated in photo to select whole sheet


2. Right click


3. Delete

Delete with VBA

Option Explicit

Sub test()

 Dim ws As Worksheet

 With ThisWorkbook

 For Each ws In .Worksheets
 ws.Cells.Delete
 Next ws

 End With

End Sub

share|improve this answer

answered Mar 24 at 14:00

Error 1004Error 1004

4,3992625

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @giorgilomidze did you try this solution?
  
  – Error 1004
  Apr 5 at 12:56
  

  
  
  
  

add a comment | 

0

I Think this is Excels Bug: If you will hide for example all rows starting 10th and then you will click via mouse on the thin line for unhiding. if you will click unhide there will be only last row. others will be still hidden. after you will unhide others and save file you will get 2.5 MB size of excel file.

share|improve this answer

answered Mar 26 at 16:54

giorgi lomidzegiorgi lomidze

107

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55322863%2fcompletely-clear-workbook-has-5-mb-size%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Is not empty. The worksheets contain information about previous data (like cell formats etc..). You can clearly see it in the below screenshots.

Worksheet with information, excel allows you to draw to last existing row/column with information:

Worksheet with no information:

A way to remove the data could be with VBA, for example this one: Why does my excel document have 960,000 empty rows?

share|improve this answer

answered Mar 24 at 11:06

WizhiWizhi

3,45421131

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  1) There is no data, 2) There is no Data Validation 3) There is no Conditional Formatting 4) No comments 5) all cell, rows, columns I have deleted via "clear all", via VBA, via "delete rows", via delete columns, via ctrl+a and "delete".
  
  – giorgi lomidze
  Mar 24 at 11:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So if you go to cell A1 and hit Ctrl + End ... it doesn’t send you to some cell down the page?
  
  – Skin
  Mar 24 at 11:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeah weird, I deleted both sheets and added a fresh one and it was still over 200kb's. A brand new workbook was 8kb's. Fun ...!
  
  – Skin
  Mar 24 at 11:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes, that is very weird. some steps helped in but not the exact problem has not been identified.
  
  – giorgi lomidze
  Mar 24 at 12:02
  

  
  
  
  

add a comment | 

0

Is not empty. The worksheets contain information about previous data (like cell formats etc..). You can clearly see it in the below screenshots.

Worksheet with information, excel allows you to draw to last existing row/column with information:

Worksheet with no information:

A way to remove the data could be with VBA, for example this one: Why does my excel document have 960,000 empty rows?

share|improve this answer

answered Mar 24 at 11:06

WizhiWizhi

3,45421131

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  1) There is no data, 2) There is no Data Validation 3) There is no Conditional Formatting 4) No comments 5) all cell, rows, columns I have deleted via "clear all", via VBA, via "delete rows", via delete columns, via ctrl+a and "delete".
  
  – giorgi lomidze
  Mar 24 at 11:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So if you go to cell A1 and hit Ctrl + End ... it doesn’t send you to some cell down the page?
  
  – Skin
  Mar 24 at 11:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeah weird, I deleted both sheets and added a fresh one and it was still over 200kb's. A brand new workbook was 8kb's. Fun ...!
  
  – Skin
  Mar 24 at 11:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes, that is very weird. some steps helped in but not the exact problem has not been identified.
  
  – giorgi lomidze
  Mar 24 at 12:02
  

  
  
  
  

add a comment | 

Is not empty. The worksheets contain information about previous data (like cell formats etc..). You can clearly see it in the below screenshots.

Worksheet with information, excel allows you to draw to last existing row/column with information:

Worksheet with no information:

A way to remove the data could be with VBA, for example this one: Why does my excel document have 960,000 empty rows?

share|improve this answer

answered Mar 24 at 11:06

WizhiWizhi

3,45421131

share|improve this answer

answered Mar 24 at 11:06

WizhiWizhi

3,45421131

answered Mar 24 at 11:06

WizhiWizhi

3,45421131

answered Mar 24 at 11:06

WizhiWizhi

3,45421131

0

You do a test . If you shift Control plus End you will reach to Row No. 1048576 but If you take a new work book and fill range "A1:J15" you will reach Cell "J15" . This shows the effect of previous data and formats, auto filters.

share|improve this answer

answered Mar 24 at 11:28

skkakkarskkakkar

2,3132924

add a comment | 

0

You do a test . If you shift Control plus End you will reach to Row No. 1048576 but If you take a new work book and fill range "A1:J15" you will reach Cell "J15" . This shows the effect of previous data and formats, auto filters.

share|improve this answer

answered Mar 24 at 11:28

skkakkarskkakkar

2,3132924

add a comment | 

You do a test . If you shift Control plus End you will reach to Row No. 1048576 but If you take a new work book and fill range "A1:J15" you will reach Cell "J15" . This shows the effect of previous data and formats, auto filters.

share|improve this answer

answered Mar 24 at 11:28

skkakkarskkakkar

2,3132924

share|improve this answer

answered Mar 24 at 11:28

skkakkarskkakkar

2,3132924

answered Mar 24 at 11:28

skkakkarskkakkar

2,3132924

answered Mar 24 at 11:28

skkakkarskkakkar

2,3132924

0

If only on sheet had data:

1. Press the arrow indicated in photo to select whole sheet


2. Right click


3. Delete

Delete with VBA

Option Explicit

Sub test()

 Dim ws As Worksheet

 With ThisWorkbook

 For Each ws In .Worksheets
 ws.Cells.Delete
 Next ws

 End With

End Sub

share|improve this answer

answered Mar 24 at 14:00

Error 1004Error 1004

4,3992625

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @giorgilomidze did you try this solution?
  
  – Error 1004
  Apr 5 at 12:56
  

  
  
  
  

add a comment | 

0

If only on sheet had data:

1. Press the arrow indicated in photo to select whole sheet


2. Right click


3. Delete

Delete with VBA

Option Explicit

Sub test()

 Dim ws As Worksheet

 With ThisWorkbook

 For Each ws In .Worksheets
 ws.Cells.Delete
 Next ws

 End With

End Sub

share|improve this answer

answered Mar 24 at 14:00

Error 1004Error 1004

4,3992625

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @giorgilomidze did you try this solution?
  
  – Error 1004
  Apr 5 at 12:56
  

  
  
  
  

add a comment | 

If only on sheet had data:

1. Press the arrow indicated in photo to select whole sheet


2. Right click


3. Delete

Delete with VBA

Option Explicit

Sub test()

 Dim ws As Worksheet

 With ThisWorkbook

 For Each ws In .Worksheets
 ws.Cells.Delete
 Next ws

 End With

End Sub

share|improve this answer

answered Mar 24 at 14:00

Error 1004Error 1004

4,3992625

Option Explicit

Sub test()

 Dim ws As Worksheet

 With ThisWorkbook

 For Each ws In .Worksheets
 ws.Cells.Delete
 Next ws

 End With

End Sub

share|improve this answer

answered Mar 24 at 14:00

Error 1004Error 1004

4,3992625

answered Mar 24 at 14:00

Error 1004Error 1004

4,3992625

answered Mar 24 at 14:00

Error 1004Error 1004

4,3992625

0

I Think this is Excels Bug: If you will hide for example all rows starting 10th and then you will click via mouse on the thin line for unhiding. if you will click unhide there will be only last row. others will be still hidden. after you will unhide others and save file you will get 2.5 MB size of excel file.

share|improve this answer

answered Mar 26 at 16:54

giorgi lomidzegiorgi lomidze

107

add a comment | 

0

I Think this is Excels Bug: If you will hide for example all rows starting 10th and then you will click via mouse on the thin line for unhiding. if you will click unhide there will be only last row. others will be still hidden. after you will unhide others and save file you will get 2.5 MB size of excel file.

share|improve this answer

answered Mar 26 at 16:54

giorgi lomidzegiorgi lomidze

107

add a comment | 

I Think this is Excels Bug: If you will hide for example all rows starting 10th and then you will click via mouse on the thin line for unhiding. if you will click unhide there will be only last row. others will be still hidden. after you will unhide others and save file you will get 2.5 MB size of excel file.

share|improve this answer

answered Mar 26 at 16:54

giorgi lomidzegiorgi lomidze

107

share|improve this answer

answered Mar 26 at 16:54

giorgi lomidzegiorgi lomidze

107

answered Mar 26 at 16:54

giorgi lomidzegiorgi lomidze

107

answered Mar 26 at 16:54

giorgi lomidzegiorgi lomidze

107