Microsoft Excel - delay in directories opening

Asked By Ron Brute on 25-Oct-08 10:52 PM
when I go to save a file in excel and choose "file save as" , it takes several seconds for the directory choices to come up. Then when I finally get to choose where to save the file, each sub directory takes 20-40 seconds to come up. What is causing this delay?

Reply: - Binny ch replied to Ron Brute on 25-Oct-08 11:25 PM

It is because Yyuor ssytem is very Slow: Do the following to Increase the Performance of the PC

Use Disk Cleanup to:

1)Remove temporary Internet files.
2)Remove downloaded program files (such as Microsoft ActiveX controls and Java applets).
3)Empty the Recycle Bin.
4)Remove Windows temporary files.
5)Remove optional Windows components that you don't use.
6)Remove installed programs that you no longer use.

Speed up access to data

Disk fragmentation slows the overall performance of your system. When files are fragmented, the computer must search the hard disk when the file is opened to piece it back together. The response time can be significantly longer.

Disk Defragmenter is a Windows utility that consolidates fragmented files and folders on your computer's hard disk so that each occupies a single space on the disk. With your files stored neatly end-to-end, without fragmentation, reading and writing to the disk speeds up.

When to run Disk Defragmenter
In addition to running Disk Defragmenter at regular intervals—monthly is optimal—there are other times you should run it too, such as when:
1)You add a large number of files.
2)Your free disk space totals 15 percent or less.
3)You install new programs or a new version of Windows.

To use Disk Defragmenter:

1.Click Start, point to All Programs, point to Accessories, point to System Tools, and then click Disk Defragmenter.
2.In the Disk Defragmenter dialog box, click the drives that you want to defragment, and then click the Analyze button. After the disk is analyzed, a dialog box appears, letting you know whether you should defragment the analyzed drives.

Tip: You should analyze a volume before defragmenting it to get an estimate of how long the defragmentation process will take.

3.To defragment the selected drive or drives, click the Defragment button. Note: In Windows Vista, there is no graphical user interface to demonstrate the progress—but your hard drive is still being defragmented.

After the defragmentation is complete, Disk Defragmenter displays the results.

4.To display detailed information about the defragmented disk or partition, click View Report.

5.To close the View Report dialog box, click Close.

6.To close the Disk Defragmenter utility, click the Close button on the title bar of the window.

solution - Perry replied to Ron Brute on 26-Oct-08 12:13 AM

I suggest you to do disk fragmentation and clean up if you have not done it since long and after that also problem persist then you can understand that your Pc is infected with virur and spyware and you need to remove it.

Regards,
Megha

read this - C_A P replied to Ron Brute on 28-Oct-08 09:31 AM

Everyone knows that Windows computers can sometimes slow down over time. While not an exhaustive list of solutions to problems, this collection presents seven ways to speed up a computer.

Complete with step-by-step instructions and numerous screen shots, even novice computer users can follow these steps. The steps and screen shots are intended for Windows XP users, but users of other Windows versions can follow a similar process.

1. Defragment Your Hard Drive

Over time, the data on your hard drive gets scattered. Defragmenting your hard drive puts your data back into sequential order, making it easier for Windows to access it. As a result, the performance of your computer will improve.

2. Scan Your Hard Disk

Has your computer ever crashed, making it impossible to shut it down properly? Have you ever experienecd a power outage? These problems and others can cause damage to your system files. Windows provides a utility called scandisk that will automatically detect and fix much of the damage, improving your system's performance in the process.

3. Scan for Viruses

Viruses can wreak havoc on your computer. Detecting and cleaning viruses is an excellent way to improve your system's performance. There are many antivirus programs to choose from, but the About Guide to Antivirus Software provides a list of the Top 7 Antivirus Programs for Windows.

4. Check for Spyware and Adware

Spyware is software that allows companies to monitor what websites you visit or even access your computer. Adware is software that displays advertisements. Both use system resources and slow your computer down. Detecting and removing the programs will improve system performance.

5. Uninstall Unneeded Programs

Removing programs that you no longer use can free up space on your computer and speed up your system's performance. However, you need to uninstall the programs properly to see much improvement; deleting them is not enough.

6. Adjust Visual Effects for Better Performance

Windows XP provides a number of interesting visual effects like animated windows and fading menus. These effects, however, can slow down your computer. In this tutorial, you'll learn how to customize the visual effects to match your preferences and performance needs.

7. Stop Programs from starting on Windows boot

One way you can speed up your computer is to prevent programs from launching themselves at start-up. Not only do the unwanted programs delay the start of Windows, they also continue to slow down your computer since they use system resources.
read this link - C_A P replied to Ron Brute on 28-Oct-08 09:33 AM
http://www.microsoft.com/atwork/getstarted/speed.mspx
http://www.wikihow.com/Speed-up-a-Windows-XP-Computer
http://www.pcnet-online.com/content/general/speed.htm
http://www.masternewmedia.org/news/2006/04/12/slow_computer_speed_up_your.htm