Zharoznizhuvalny for children is recognized as a pediatrician. Allegedly, there are situations of inconvenient help for feverish women, if the children are in need of giving innocently. Todi dad take on the versatility and constipation of fever-lowering drugs. How can you give children a breast? How can you beat the temperature of older children? What are the best ones?
For a long time I have been working with the official package from Microsoft, and with a similar problem I have stumbled upon. I have to ask my colleague to file a file and ask me to solve a problem. Excel files have less than 100 rows, but it's not normal to work with them. Seredki are seen from the vidchutnoy zatrimkoy. When opening a file, the process Excel z'їdaє is close to 700 megabytes operational memory This is a number of other symptoms that do not allow normal processing of the document.
First, I was alarmed by the size of the file. For 100 rows, the size of 29 megabytes is clearly overhead. Before I tried to save the file in the confusion mode of Office 2003, it didn’t give any positive result. The file has grown even more and more important. Today I haven’t lost anything as to turn to Google for help. Through a series of tests, the formulation of new feeds was sent to me at the English Forum, and one of the participants proponed their own view of such problems.
Excel galma problem shrieked in front of the archives of a robotic book of a large number of graphic articles. You can marvel at the list of cich figures you can in the menu "Head" -> "Know that video" -> "View area".
In my vipadku їkh appeared in Mayzhe 50 thousand. The stench of the stench took hold - okreme food. The author of the file is to throw up his hands, ale me to be created, so that similar speeches are found through the last inserts in the file of the given books. Have a vipadku koristuvach, sclav the file, doing the copy paste itself. Good, the problem is clear, but what about now virishity? You can see the graphic figurines through the chain backward and backward smoothly (not forgetting, Excel yak and earlier galmu).
The axis here is to help us come the tense mechanism of macros. New macro ("Viglyad" -> "Macro") and copy in new offensive code:
Dim someShape As Shape For Each someShape In ActiveSheet.Shapes someShape.Delete Next someShape
The code is copied directly at the start of the procedure, then the start is made. Excel immediately think about and start before seeing all the objects. My fifty thousand objects have been bought for 4.5 hvili. When the procedure is completed, the output file is up to 29 kilobytes (!!!).
In fact, it’s not just the developers (my target audience), but the most extravagant ones. I respect the code for the zvyazku z tsim. Vіn vіdalya all ob'єkti s active arkush. Go to category "all" go text fields, buttons, etc. As long as your document has buttons and elements of keruvannya, it is necessary to add a filter to the cycle. You can reconsider the type of object, which is seen, as follows:
If someShape.Type = 17 Then someShape.Delete
Homing code is visible from text fields. Learn about the types of figurines you can see on
Dovge view of files in Excel can be accessed through:
- great number formatting stuck at the table
- problems with the printer
- the manifestation of prikhovanie ob'ktiv
- not sensible sucking of formulas
- a majestic size of the file, with a small amount of vicorist
- and God knows what problems there are.
Allowing Excel to add galms
The discovery of the majestic picture of the format of the presentation of the sutta to the robot Excel
View the table 65000 rows and 50 hundred percent. Kozhna komіrka maє colori, unique font and size for the text. Yak guess, will the cursor move spontaneously with such a file? If you don't have a MainFrame, it's unlikely.
Namagayte to draw up the ones that need to be done. Do not stuck the format until all the way, as you may see or even need a few more comics. Well, if after having spent such a "formatting" file, then in Excel є a miracle button - Clear Format 
Galmuvati Excel can be done through printer problems
To be more precise, it’s not connected to the printer, which the editor has vibrato for the suggestions. Ale tsya problem is typical for Eksel 2007 and seniors. Run the file to be viewed even more. To be repaired with the vibration of a new cleaning printer or the included cleaning one. For the installation of the virtual printer "Microsoft XPS Document Writer"
Revealed ob'ktyv
Prikhovani ob'єkti can be consumed to the tables through a copy of the data from the file. Moreover, the object is transferred with zero sizes, through which, when seen, it is not visible. With the great number of things, you can talk to the robot.
The problematic file appears, and it changes, so that we can know that kind of prikhovani ob'єkti. For a great onslaught, Alt + F11, open the Microsoft Visual Basic editor. Onslaught is F4, the list is selected from EtaBook Workbook and the value -4104 -xlDisplayShapes is set in the DisplayDrawingObjects field. Dal, on Ekselya's sheets, vikonuєmo Golovna - Know that vidіlity - Vidіlennya groups oseredkіv - Ob'єkti, the onslaught is OK and then the Delete key. Slyly, it is more beautiful to break a copy of a file and try it on a new one.
Rearrangement by formulas
It’s a great document, because the decalcoms are used for the aggregation of donations, then they are calculated on weak machines, laptops and netbooks, and will usually be done that way. As soon as the document "sviy" and if it can be revised, then it is necessary to replace the formulas, but not to be vicious, - meaning. It’s like that. If you see the necessary range in the middle, click the right button to select the Copy.
If you want to see the range of the click RMB, select the Special insert and insert the Value. In such a rank, the number of formulas is changed, for example Excel is guilty of carrying out rosary. 
Also, do not forget the victorious formulas:
Vikoristovyte yaksho pomilka, won vіdpratsovuє shvidshe combinatsії yaksho + ЕОШ
Pick up for converting logical values at zero and one.
It is important to vikoristovuvati the combination of INDEX + POSHUKPOZ to replace the VPR
MAX (A1; 0) pratsy shvidshe YAKSCHO (A1> 0; A1; 0)
Dovge view through great size
Moreover, it is often said that the number of data in the tables does not proportionally show the size of the file. The last one is more often. This can be done if the file is available or in Zagalny access. When the Excel mode is set, it keeps a log of changes, where to use the changes for the period, instructions for the parameters.
Vimknuti or change the period is possible in Excel 2007 and older, at the Recension Contributor - Access to the book. І on the insert List the values in more detail, as required.
If the document is saved in the xlsx format or in the xls format, you can save it in the xlsb format. І the file, from which the file is displayed, is received. Greater information is available to the extent that all data in a single file are stored in binar format, more "native" for Excel, which means fewer resources for analyzing and rewriting a document. Plus, before everything else, the size of the file is changed. 
I know, well, as long as the document is saved in the xlsx format and if you can see it, you can see it for the help of any archiver (for example, winrar) and see the revisions and worksheets folders. Persha sberіgaє all the changes to the new mode Zagalny access... Another folder to take revenge on the image. Check the operations on the copy file. Until the speech, as in the documentary image, do not forget to squeeze it. To work through the Format tab - Group Zmіniti - Stisnennya malyunkіv and vkazati brighten yakіst. It is also possible to change the size of the image, which is positively aligned to the size of the file. 
The file can be launched in Excel 2003 and 2007, as the document is displayed from stocking resource... Ale when copying to a local computer, it starts up quickly. To see the prices of all weekdays and additional values:
HKEY_CURRENT_USER \ Software \ Policies \ Microsoft \ Office \ 12.0 \ Excel \ Security \ FileValidation (for 2007)
HKEY_CURRENT_USER \ Software \ Policies \ Microsoft \ Office \ 11.0 \ Excel \ Security \ FileValidation (for 2003)
Enableonload = dword: 00000000
This parameter is used to enable the Office File Validation function, which is used for converting the two-way file format and for converting it, which is displayed for the MS Office file format.
Turn on \ Turn off the batch processing
Tsey parameter is located in Nalashtuvannya - Dodatkovo - Formulas tab. Due to the obviousness of several processor cores, it is necessary to enable the item and enable a number of streams, as well as the additional number of cores. As soon as it was done with a galvanized parameter, then turn it on. In the ideal, the price of setting up will speed up the robot before an hour of robotics with formulas.
I am encouraged to write all the manipulation files you will not be able to display anymore, and Excel is not galmuvatized at startup.
І lower, duzhe tsіkave and lectures video with comments, like speed up the Excel robot
Problem, wienikla z Microsoft Excel 2016 on the client's computer, when the computer itself is “without galm” and freezing.
Installed Windows license 10 and Microsoft Office 2016.
Microsoft Excel is hot when the value is entered into the room, reacting with a great light (about 10 seconds).
At the same time, the table file is small, the table is installed on the computer, and not exported from zvnishny supplement(For example 1C).
The problem is screaming at a weak configuration this computer(At the same time, it is enough for a robot, a manual robot of a computer).
[File]➙ [Parameters] ➙ [Dodatkovo] ➙ [Screen] ➙ [Vimknuti apparatne deprived of accelerated image processing] ➙ [OK]
Image 1. Microsoft Excel 2016 vimknuti hardware image processing
Pislya vikonannya given, the main problem is due to the introduction of tribute from the commissary, the bully is usun, a little can be seen from the menu.
Dodatkovo boules introduced changes to the parameters of the Windows 10 shvidcode (given the parameters available from the system authorities).
➙ ➙ [Dodatkovo] ➙ [Shvidkodiya] ➙ [Visual Effects] ➙ [Special Effects] ➙ [OK]
The bulo is set to the following parameters:
Image 2. Windows 10 reduced shwidcode
Qia Diya allowed me to put the galmuvannya before the hour of the robot Microsoft Excel 2016.
At the same statistics, there are a number of problems, which may help us to find out some of the broader problems when Excel is not rejected, Excel hangs or stops trying to write the book to start Excel, but see. Such problems can be attributed to one or more reasons below.
Get the right decision in the order of the statty. If you tried one of these ways before, you didn’t allow to go over to the next one on the list.
Start Excel in Bakeless Mode
The baked-on mode allows you to start Excel without being aware of the launch of the programs. You can view Excel in ovenless mode, having pressed that Ctrl when starting the programs, or vikoristyuchi / safe option(/ Safe excel.exe) before starting the program command line... When you start Excel in a safe mode, it skips the functions and parameters, such as additional auto-provisioning, changing toolbars, the xlstart folder and Excel overloading. Protect COM wake up will be enabled.
I also got a problem with the virus when launching Excel in a non-oven mode, div. Correcting malfunctions, scho to find out the hour when Excel is installed.
If the problem is not visible when starting Excel in a non-oven mode, go to the next step in the list.
Restoration of the rest
You can set the Center for your needs. Windows update for automatic entrapment This setting is recommended. The introduction of some important recommendations and optimization of new developments can often lead to problems replacing old files and variability. The installation the last change for Office, visit this page: Office Updates and Computer.
Even though the update for Office did not fix the problem, go to the offensive list.
A reversal of the fact that Excel is not victorious in this process
As soon as Excel is victorious, it’s a process that will be displayed next to a row at the bottom of the Microsoft Excel window. When trying to find out what Excel does for an hour, Excel may not be displayed. Check in, while in the process of completing the project, before the activation of the project.
As far as Excel is concerned, it doesn’t take a toll on the process, go to the offensive item on the list.
Revealing potential problems due to overdue
If it’s possible to broaden the possibilities, the stench may have caused some confusion with Excel. Try to run Excel without any problems or problems, as long as the problem is not known.
Yaksho vi vikoristovute Windows system 10, vibrate Start > Try programs > Windows system > Viconati> introduce Excel / safe at vіknі " viconati"and then press the button OK.
Yaksho vi vikoristove Windows 8, vibrate the command viconati near the program menu> enter Excel / safe at vіknі " viconati"and then press the button OK.
As soon as you win Windows 7, press the button Start> enter excel / safe y field Know programs and files, and then press the button OK.
Point one at the bottom of the screen.
As soon as the problem is violated, click File > Parameters > Nadbudovi.
Oberit wake up COM press the button Go to.
Know usi warrants from the list and natisnit OK button.
Close Excel and start again.
If the problem is not guilty when starting Excel, it’s not possible to fix the problems for one hour, the docks are not allowed. Tse allow z'yasuvati, as the cause of the problem. Change over to restart the skin once, if Excel is inserted.
I didn’t see the problem, go to the offensive item on the list.
Analyze the views about the Excel file and vmist
Excel files can be known on a computer for three hours. The stench will be updated to the version and will often be overpowered from one koristuvach to one koristuvachev. As a rule, I will use the Excel file, but you don’t know what is included in the file. You can step up to productivity for the nutritional supplement:
It’s a reference to an unpaired number of elements in the arguments of the Array Formula.
Hundreds of mossy thousand objects are prikhovanny or 0 height and width.
We'll borrow styles, wikis are often victorious when copying and pasting books.
The singing of the name is unacceptable.
Even though they didn’t see the problem, go to the next step on the list.
Install the patron saint of the file
Inodi third-party programs are used to store Microsoft Excel files. At all, the files may be wrong, and the functions may be wrong before the hour of opening the files in Microsoft Excel. There are a lot of changes in the possibilities of a new file due to the interdependence of a third-party virobnik. If the function is correct, it is necessary to change the position of the third party about the problem.
As soon as you change the posture by the program of third parties, your problem is not put down, go to the offensive item on the list.
Viconite Vibirkovy launch, what is the value, the conflict of the program, the process or the service behind the help of Excel
At running Windows Deyakі programs that service started automatically, and then run in the background. The programs and services can be assigned to the software security on a computer. Vikonannya Vibirkovy launch (also vidomy yak "purely entangled") additionally helps to identify problems with conflicting programs. Vibrate Vibrate launch, vibrate one hover below, one lowers one established version Windows, and then take a look at the instructions on the statti:
Vibrating launch vikoristovuutsya for the emergence of an intelligent process, service, or programs, scho conflict with Excel.
If the problem is not resolved after re-opening the profile, go to the next step on the list.
Updating Office programs
Updating Office programs may have problems with Excel not being displayed, or freezing the automatic update function for Office files. Schob іtrimati іnstruktsії, div. Updating Office programs.
Even Office does not list the problem, go to the offensive item on the list.
Revision of the relevance of the version of antivirus programs and the manifestation of conflicts from Excel
As the anti-virus program is not updated, Excel may be wrong.
Reversion of relevance anti-virus programs
To get out of new viruses, the administrators of the anti-virus programs periodically release updates, as it is possible to blackmail them from the Internet. Add new updates by opening the site of the provider with anti-virus programs.
List of suppliers of anti-virus programs. at statti Razrobniki anti-virus software protection for Windows.
Reconstruction of the confidentiality of conflicts from Excel anti-virus programs:
As an anti-virus program, we can integrate with Excel, it is possible to deal with productivity problems. In such a way, you can get Excel integration from antivirus software. It is also possible to download all the anti-virus programs installed in Excel.
Importantly: A change in the parameters in antivirus programs can lead to the inflamedness of the computer for viral, Shakhraysky or high-profile attacks. Microsoft does not recommend changing settings for antivirus software. Vikoristovyte the price for your fear and risk.
You can, you will be able to turn up to the head of the anti-virus programs, you should know, how to fix it in such a rank, you will not be able to stop integrating with Excel or scanned into Excel.
additional views
Dodatkovi ways of usuning injustices
As soon as the methods that have been guessed before have not solved the problem, the problem can be either a file of singing or new middle ground. Below is a description of usunennya predatkovyh problems, which can cause to the brink of failure in Excel.
Dovkilla factors
Usunennya inadequacies of the factors of the navkolishny midst є mensh are important, below the file and overdue. To help you find the cause of the problem by visiting the following:
Vicon delight in the experience of injustice.
Reversion of files in the cleanest middleware.
At the onset of razdіlakh described deyakі oblastі, as varto dіznatisya.
Defend the file
Move the file to local computer help if there is a problem with the file or in which file is saved. Deyakі problems can be found out with the saved Excel file through a net or a web server. It is recommended to save the file to your local computer. Tse slid robiti in such cases:
Redirecting the "Documents" folder to the server roztashuvannya
Standalone files
View files from SharePoint or Webfolder
Work style update for Citrix
Merezhevikh annexes
Virtual middle ground. additional views about the software security of the Microsoft corporation, as a visitor to the virtualized middle of the upcoming statistic: The policy of generating for launching the software secured virtualization of the possession of third-party software security.
Memory
Excel files can be great if you add a great number of formats to that figure. Perekonayte, so get the RAM to run the programs. Vimogi to the system for a set Microsoft programs Office go to these Microsoft articles:
Office 2010 implemented 64-bit version Office products cross-roads of a large number of obrobka. To learn more about the 64-bit version of Office, go to the following Microsoft articles:
Printer and driver video
When you start Excel, you will change the printer for promos and video drivers that are displayed in Excel workbooks. Excel is an intensive printer and will be more efficient if you save your Excel files. Testing a file, printing a printer, for example, a printer driver will write XPS-documents in Microsoft or a VGA video driver, if there is a problem with the current printer or a video driver.
It’s all the more heartless, or even if there’s a problem in Excel, for an hour or so, for other separate buildings, it’s described here, you need to call the Microsoft support service for interactive troubleshooting.
additional views
You can supply power to the Excel Tech Community, ask for help from the Answers community, and also proponate new function or abbreviated to the website
Good day, good reader!
In this article, I want to look at the topic of Excel efficiency and learn what Excel is about, as well as give 12 ways to rotate Excel files for the robot! Surely, as long as you do not have a lot of tables, because you don’t need to expand between Excel’s vicissories, so the statute will not be tricky, but as soon as all the navpaks are ready….
If there are such vipads, if the Excel files are "banged up" and the praisezdatnist is of a very small magnitude. You can, send you a file that is even great and important, and for that, you will be able to save yourself a little, but all the same ... Let us understand the causes of such problems and the main ways to overcome them.
The problems with "galvanizing" MS Office are broadened in Excel robots. Problematic Excel robot There are many reasons for this: you can use Excel functions above the world, you can use data, additional data and tables, and a lot of them.
And now let's go from the theory to the next 12 ways, how to allow you to wake up the "galm" Excel and start working comfortably:
1. Change the size of pictures
The most effective way to change the size of your file is to correct it over the pictures in a new one. Ale sposib work, as the image is still vikoristovuvali.
If you gave a picture through the menu on the Keruvannya panel "Insert" at the blots "Ilustratsii" rushed "Malunok", Todi file is sewn in by little ones with a new volume. And now it is necessary to make changes, place the cursor on the picture, and a new tab appears "Robot with babies" with a tab "Format"... At the blots "Zmini" click the button "Clutch the little ones".
At the dialogue window "Stisk malunkiv" specify a specific option to change the size and pressure "OK". 
Do not forget to forget about those pictures that can be used.
2. Replaced by macros great formulas
At vipadkas, if the table is large, for tens of thousands of rows, and there are a lot of folding formulas, which can be used for creative books and sheets are produced before Excel is galmu. For the reduction of varto, it is necessary to replace the written formulas, the odor of the stench, to re-translate the formulas into the copied meaning of the text, the figure and the meaning. It is even more useful in the case of multiple files for a file, if it is carried out more often than the rest of the data for the entire file.
3. Adjust the Excel spreadsheet format
In the case of vipads, if the formatting is stuck in the view of special tables, and the tables themselves reach a great size, it can make Excel robots very difficult.
If the table itself is formatted, you can simply, by placing the cursor on it, a supplementary tab will appear in the control panel "Robot with tables"... Vibrate the tab "Constructor", shukayte razdil "Servis", push the button "Transform to range" and confirm that you will need to convert your table to a custom one. 
4. Vidalyaєmo unused 100 rows
The problem has been expanded for an hour of robots in Excel. Call koristuvach vipadkovo move for help Ctrl + arrow right-handed abo way down, natisnuti vypadkovo, and transferred to the end of the arkush, that is how I am working on the book, at the same time it is meaningfully accelerated. It is especially important to see if a vague symbol, or a fill sign, is delivered to the end of the book.
Revision of this option is possible for a characteristic familiarity, and even a small povzunok. 
5. Change the format of the workbook to * .xlsb
In vipads, if your robot is tied with magnificent tables and the size of the reach of great promises, then there are many robotic books in the format * .xlsb... The price of the expansion is a double format, a unique special format for the creation and storage of your electronic tables, which may be the basis.
If you will be saved in a whole format, whether a great file changes immediately 2-3 times, before speech, the number of times will also be increased by several orders, so that you are welcome.
6. It is taken away from the world beyond the format
Unimportant for the entirety of the mental format, you can bring problems to your mind, your working book can go a long way. It is possible to navigate without your view, just in the process of the robot you copy several formats at the same time to the formats, and you can not go through the impatience, the stench accumulates inconceivably and gallows the file to the robot.
For the best view of everything, for the cob, select the required range, or the entire working sheet is possible. Step crochet on the keruvannya panel, at the deposit "Golovna" in razdіlі "Styles" select the item from the menu, scho vipada « Mind the format»
, given required item "See the rules" that you select the required item of the video. 
7. Vidalyaєmo not needed data for all the structured Excel file
I can argue that it is far from being skinny, but the Excel files are a free archive and such a file structure has been sent since 2007. And this means that Excel files can be viewed by an archiver, such as WinRar. And the axis is in the middle of the file and can be used for files, such as, in some cases, it is significant to galvanize Excel.
To carry out the procedure for changing the size, play it safe, and grow backup copy file. Then open the file behind the help of the context menu, open the file by clicking on the right button and clicking the item "View with help" i s available programs select the program archivator Abo, another option, display the archivator in the menu "File" click on the item "View all the middle"... The result of any option will be to display an Excel file, like archives with files and folders.
In archiv, shvidshe for everything, at the papa "xl", see folders "printerSettings"і "Drawings". 
Letting all the torments know how to launch the file and on all the system's installation by pressing the button "OK", the file is updated and started.
I wrap up your respect, if the file is to take revenge on the malovan about the type of buttons chi figur, then you can see the whole folder "Drawings" it’s not so, at once from it to viparuyutsya і figurines. Papa has enough vmlDrawing.vml How to take revenge on useful information and can reach great changes.
8. Incorrect layering on the printer
I didn’t install the printer because of the promises і the system cannot be significant, it is necessary to clearly identify, where will it be supported by a friend. As the printer is uncomfortable to recognize, I will add the driver to replace it.
In order to run it so that erasing the printer setup from step 7 can lead to the wrong printer setting up the entire file.
9. Change the Excel version for change
It is necessary not to stand at the point, to navigate our planet, so Excel grows, even the perfectness is dumb between. Change and grow software product, optimize software code It is allowed, in one sense, to increase the productivity of the robot with tables and formulas, the speed of code can be increased up to 20% in newer versions, for example, in 2016 and 2007.
It is also often the case that Excel version 2007 cannot be processed with a stream file, and the axis of the newer versions of any problems is dumb and everything is good.
Confirm the version, go to the productive products of MS Office, from 2013 version and version.
10. The file "Personal. *"
Basically, the main purpose of the file is to collect information about the front robots in Excel. Win additional help to write down that zapam'yatovuvati macros, zberigati format of tributes for your books. As simple as it seems, it’s necessary that you don’t rob the file itself, but when the file is displayed, all personal adjustments are saved in a special file and are created when the file is opened.
Problems can be diagnosed, as soon as they grow, galmaє file of personal nalashtuvan. For usunenya problems, speed up the principle, no file, no problem. Know Z: \ ... \ Application Data \ Microsoft \ Excel \ XLSTART abo Z: \ ... \ Microsoft Office \ Office12і here at nadrakh cikh folders joke the file "Personal. *" and be aware of it.
11. Conducted optimal adjustment of the tables
If you look at the tables, try the great ranges from tens of thousands of rows, you will repair all the results of your projects, which become colossal, take away from your own. The first reason for galvanizing galmuvannya pіd hour robots with a file. To see the reason, place the cursor on the table, wipe the context menu with the right mouse button, then select the item "Parameters of the created table" at the dialogue window on the deposit "Dani" check the box "Take back data from one file at once".
You can change the file practically by means of diyami.
12. Taking away unused objects
Often, if you transfer and copy information from your working files to your sites, the structures of the tables can be used to adapt to the type of figures, children and others.
To see such unnecessary objects, you need to run a macro, click hot combination clavish Alt + F11 for the editor wikiku that paste the code.
