Office 2007 share open multiple spreadsheets often lag circle

System is Windows 7 64 - bit

Computer configuration is as follows:

G2020, 4 g memory

Network share 6.7 spreadsheets open at the same time, often, the phenomenon of the jammed in

There are about 20.30 in one spreadsheet multiple tables, table a large amount of data content

Open the other spreadsheet content is differ, some table less, some more than table

Operators, in the table, query modification work


Bothering me for several days, don't know how to solve, the novice webmasters, looked great god help me to check it out!!

CodePudding user response:

What method can optimize spreadsheet

CodePudding user response:

Better is saved as XML format

CodePudding user response:

Upgrade excel2013 KMS activation, a new optimization of good, 07 version easily

CodePudding user response:

Machines of small memory, increase the memory best 8 g, 16 g...
Spreadsheet work thin to select all cells, unified best use a font, cancel the word wrap that can to a certain extent, such as optimizing the performance of the form,

CodePudding user response:

And an also have relations

CodePudding user response:

reference 5 floor lich2005 reply:

machines of small memory, the best 8 g memory, 16 g...
Spreadsheet work thin to select all cells, unified best use a font, cancel the word wrap that can to a certain extent, such as optimizing the performance of table,

Is the 4 g, and even?

CodePudding user response:

Accustomed to use office 2010 edition