1

Topic: EXCEL From for what the Big file size

Hello world!
To our employee sent an EXCEL-file, the size 4.
Consists of 1 sheet. On it title and the table.
If to select sheet, to copy and interpose into a new file. That at it will be the size of 12 KB.
Attempt to find objects (Glavnaja\to Find and to allocate \Selection of Group Jacheek\Objects), also did not crown success.
Prompt, what it is possible to try?

2

Re: EXCEL From for what the Big file size

Yagrus2 wrote:

If to select sheet, to copy

to select and copy sheet? Or all cells of sheet?

3

Re: EXCEL From for what the Big file size

Still there can be latent sheets

4

Re: EXCEL From for what the Big file size

Shocker. Pro wrote:

it is passed...
To select and copy sheet? Or all cells of sheet?

If to select all cells (angular , in the top, at the left) to copy and interpose into other file - the Size of 12,5 KB
If "to Move or copy" the selected sheets / to Create a copy in the new book - the Size of 37,9 KB

5

Re: EXCEL From for what the Big file size

Shocker. Pro wrote:

Still there can be latent sheets

In the source file one sheet

6

Re: EXCEL From for what the Big file size

Still wanted to add, the source file opens in a compatibility mode.

7

Re: EXCEL From for what the Big file size

1) and what for it to learn
2) what extension at a file?
If.xlsx - rename in.zip,  and consider all interiors

8

Re: EXCEL From for what the Big file size

Yagrus2 wrote:

opens in a compatibility mode.

that is sent xls, and save xlsx?

9

Re: EXCEL From for what the Big file size

Shocker. Pro;
Yes

10

Re: EXCEL From for what the Big file size

Vladimir Baskakov wrote:

1) and what for it to learn

Real curiosity.

11

Re: EXCEL From for what the Big file size

Yagrus2 wrote:

Shocker. Pro;
Yes

So save sheet in that and look - how many it weighs (((((

12

Re: EXCEL From for what the Big file size

Vladimir Baskakov;
Made so:
1. Opened initial xls a file in 2010 EXCEL.
2. And further "to Move or copy" the selected sheets / to Create a copy in the new book / Saved in a format xls
The size turned out - 63 KB
At saving the warning jumped out:

13

Re: EXCEL From for what the Big file size

This message does not concern an essence of the matter. To tell the truth - binary  did not dig.
But I know that at saving in csv sometimes the heap of blank lines below is attached. On what it depends - I do not know.
If save in new,   and  can find, in what emptiness was hid. That devoured a place. And can and is not present..... Well or put in a subject a file.
Who with curiosity can digs out.........
Or read Marx
https://msdn.microsoft.com/en-us/librar … e/cc313154 (v=office.14).aspx

14

Re: EXCEL From for what the Big file size

Can resources any remained, type of pictures, at sight from deleted, and the object remained (well or the place selected under it was not compressed)

15

Re: EXCEL From for what the Big file size

And if it is simple  a file in xls, the size is saved?
If yes, it is possible still so to try - to pass for the last filled line, to select all blank lines till the end of a file and to delete (through "to delete a line"). The Same for columns. And to save.

16

Re: EXCEL From for what the Big file size

There is such business.
Saw a little absolutely empty files EXCEL in the size in some tens megabytes.

17

Re: EXCEL From for what the Big file size

Vladimir Baskakov wrote:

if save in new,   and  can find, in what emptiness was hid. That devoured a place. And can and is not present..... Well or put in a subject a file.

Changed a filename extension on.zip, and then pulled out contents 7Zip th.
Unfortunately, received files Notepad ++ normally did not open.

18

Re: EXCEL From for what the Big file size

Still so made.
From the source file, with the help to clear everything, deleted sheet contents. The file size especially did not change.
Actually, tried to lay out a file, but it did not turn out. Probably because of the size

19

Re: EXCEL From for what the Big file size

After archiving times received 3 files, one of which Workbook, here with such contents

20

Re: EXCEL From for what the Big file size

21

Re: EXCEL From for what the Big file size

Yagrus2 wrote:

Changed a filename extension on.zip, and then pulled out contents 7Zip th.

And sense? A new file xlsx small, at us a problem with  - xls

22

Re: EXCEL From for what the Big file size

Shocker. Pro wrote:

Can resources any remained, type of pictures, at sight from deleted, and the object remained (well or the place selected under it was not compressed)

But I checked it, with the help to Find and select

23

Re: EXCEL From for what the Big file size

Shocker. Pro wrote:

it is passed...
And sense? A new file xlsx small, at us a problem with  - xls

Why speak about a binary file? Unless xls is not normal 2003 excel?

24

Re: EXCEL From for what the Big file size

Yagrus2 wrote:

Why speak about a binary file? Unless xls is not normal 2003 excel?

well so it binary. Unlike xlsx which dial-up of text xml-files is

25

Re: EXCEL From for what the Big file size

Yagrus2 wrote:

But I checked it, with the help to Find and select

Not, it so is not, it is remote. Simply in the file there was a place which has been selected under object. It as from a DB - if from a DB to delete the data, it does not mean that the file of a DB the automatic machine becomes less without special measures on compression. Probably there was any glitch with this file and a place selected under object, remains occupied though the object already as though is not present.