Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 42
Default Increase PF Usage

Hi

Is it possible to increase PF Usage or Physical Memory to have a program, in
my case EXCEL, run faster.

When running a big EXCEL file, say 28MB, the file takes ages to update. When
running an EXCEL update my system usage is 63% CPU Memory and 685MB PF Usage.

Ta

EricB
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 132
Default Increase PF Usage

Some Hints:-

1) Close Unwanted Applications / Programs when it is not in use.
2) Minimize the applications when it is not in use.
3) Remove the Unwanted system startup programs.
4) Dont keep too much of Shortcut links in your Desktop.
5) Avoid adding quick launch icons in Task Bar at the time of installing
programs.

All the above will consume more RAM memory and if possible to increase your
RAM capacity based on your system configuration.

Additional Informations:-
Clear the Temp Files / Temporary Internet Files on a periodical basis.
Run%temp%Ok

Do De-fragmentation
StartProgramsAccessoriesSystem ToolsDisk Defragmenter.

To check your Paging File allocation Press Windows+Pause Break Key from your
Key Board (Or Click My Computer and do right click in the middle of the
explorer window select Properties) Which will get you system
propertiesAdvancedPerformanceSettingsAdvan cedVirtual MemoryClick
Change.

Hope this will help you€¦

--------------------
(Ms-Exl-Learner)
--------------------


"EricB" wrote:

Hi

Is it possible to increase PF Usage or Physical Memory to have a program, in
my case EXCEL, run faster.

When running a big EXCEL file, say 28MB, the file takes ages to update. When
running an EXCEL update my system usage is 63% CPU Memory and 685MB PF Usage.

Ta

EricB

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,203
Default Increase PF Usage

You haven't mentioned how much physical RAM you now have in the computer.
Simply adding RAM is one of the quickest (and usually least expensive) ways
of physically altering the computer and get better performance out of it.

Ms-Exl-Learner has given you a good list of things to think about to improve
performance. As far as Page File size, I'd let Windows manage it although
looking to see what it's set for is just fine for the curious. All versions
of Windows since XP have done a very good job of managing the virtual memory
and even of managing the TCP/IP input buffer size (which is not of concern in
this case, just thought I'd mention it).

"EricB" wrote:

Hi

Is it possible to increase PF Usage or Physical Memory to have a program, in
my case EXCEL, run faster.

When running a big EXCEL file, say 28MB, the file takes ages to update. When
running an EXCEL update my system usage is 63% CPU Memory and 685MB PF Usage.

Ta

EricB

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT usage wild turkey no9 Excel Worksheet Functions 5 April 25th 09 10:30 AM
Number in cell increase with increase in font size. Value increases with increase in font.[_2_] Excel Discussion (Misc queries) 2 August 9th 07 01:58 PM
limited usage jinvictor Excel Discussion (Misc queries) 1 June 14th 06 04:28 PM
100% cpu usage bill Excel Discussion (Misc queries) 1 March 2nd 06 10:27 AM
Restricted Usage AB Excel Discussion (Misc queries) 5 February 2nd 06 09:00 PM


All times are GMT +1. The time now is 05:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"