Question about Computers & Internet

3 Answers

Excell 2007 very slow to open

System running xp-pro sp3

Posted by on

3 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Guru:

    An expert who has written 7 tips or uploaded 3 video tips

  • Master
  • 829 Answers

Speed up Excel 2007 startup The Problem If Excel isn't running already, double-clicking a file will start Excel itself almost immediately, but the clicked file will be loaded only after about one minute.
The Solution At least on Windows XP the problem can be solved as described below.

  1. Application Explorer
  2. Menu Tools
  3. Menu item Folder Options
  4. Tab File Types
  5. List item XLS
  6. Button Advanced
  7. List item Open
  8. Button Edit...
In the dialog box that appears you need to make two adjustments:
Application to perform action:At the end of the line after /e append a space character followed by "%1" (including the quotes)DDE Application Not Running:Insert new text: [rem see command line] (including the brackets) Details We experienced the problem after updating to MS Office 2007. My father noticed that an Excel sheet gets loaded immediately if you include the path of EXCEL.EXE in the command line. Loading documents via DDE, as Explorer does it, seems to take much more time, at least if the application is not already running. The modifications described above will pass the file path immediately when the application is started, the DDE command that gets executed later on is only a remark, as an empty field would result in passing the default action from two lines above that field. The /e seems to ensure that Excel will not open an empty sheet, so I originally dropped that because usually no empty sheet is opened when a file is specified. However I got a report from someone using /e, and as it didn't cause any harm for me either, I now suggest to leave it in place. If Excel is running already, additional documents will be opened via DDE as before, resulting in only one Excel process running.
Word Time and again I've been asked whether I knew a similar trick for Word. Even without any tricks Word starts fairly fast, but even there adding "%1" gave me a slight increase in startup speed. I don't exactly know what this [REM _DDE_Direct] is. It looks like some kind of "special comment", that could have some effect despite being a comment. I decided to copy that comment to the DDE Application Not Running box, and could not detect any ill effects. I also kept the /n and the /dde on the command line, simply because I could find no harm in it.
Uninstall If you try out these suggestions, but they don't work out for you, reverting to the way it was before might prove more difficult than you would expect. It seems the dialog where you make your changes will always append a %1 to the command line when you press OK and it isn't present already. The only solution I could find was using regedit to remove the %1 without using the dialog. The command is stored under the default key at HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command. If you choose to revert the DDE settins using regedit as well, you can simply remove the whole ddeexec\IfExec subtree.

Posted on Feb 02, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

I just changed the contents of the icon box (top box) in files option menue to "Microsoft Office Excel 97-2003 Worksheet" then it worked.

Posted on Jul 06, 2010

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Actually in my excel worksheet only one worksheet is getting hanged during workout wrest of all worksheets are fine.please guide me what could be done regards this.

Posted on May 25, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to replace the batteries


For BP1000 model you can open the front of the UPS so that you can change the battery. Just pull the front cover towards you and open the 2 screw in front and you are ready to replace your UPS battery

Mar 17, 2012 | APC Back-UPS Pro 1000VA (BP1000) UPS...

1 Answer

Had a power break, expected power to come back so


t_sleeswijkv, Your unit may need factory servicing. Could have been hit with a large overvoltage transient spike that may have damaged unit electronics. Give a call to APC or visit their website for more advice on best way to proceed. I hope it never happens to my APC 1250. I did a DIY replacement of 2 batteries in mine back in 2007 because one went bad. If your unit not covered by warranty open it and take pics of what stuff got burned-up or fried. let us know what you find. 12fixlouie on fixya

Mar 17, 2010 | APC Back-UPS Pro 1100 (BP1100) UPS System

1 Answer

Volt meter shows 26 volts(2 12 volt in series) but wont run lawn mower. jumped 12 volt car battery and this runs mower at slow speed. is battery dead


Sounds as if battery has internal short. Also have charging system checked. If doing yourself check amperage also. Charging volts and no amps wont work or overcharging. Over charging will ruin a new battery. Also make sure you have clean solid connections between cable ends and battery. Take cables off and clean very good poor contacts will give false readings when checking system.

Jun 27, 2009 | Panasonic LC-X1220P - UPS battery - 1 x...

1 Answer

UPS periodically disconnects


You have a smart chip problem. Your unit is too small that would be cost effective to repair.

check out my web page:

www.storminprotection.com.

I will help you save a few dollars but I think you might need a little bigger UPS then a 550. Try going bigger.

Mar 14, 2009 | Belkin (F6C550-AVR) (DBF6C550AVR) UPS...

1 Answer

Software problems and power shutdowns


so i would suggest to look into your add/remove programs and see is their is the older file still their. if thier is then you may need to uninstall it. however getting any program to startup in your computer, you just need to move the programs files to the startup folder in your start menus.

Aug 07, 2008 | Energizer ER HM450 (ER-HM450) UPS System

3 Answers

Ikasu wireless keyboard and mouse


Hi I have IKASU W-K-with trackball. I run Vista i just pluged it in and windows found the drivers.I allso run Driver Detective.Hope this helps.dave

Jun 29, 2008 | Computers & Internet

1 Answer

APC communication error message


Try going to the properties of the driver and select do not check or check every X mintues.

Try this thanks J

Dec 13, 2007 | APC Back-UPS ES 725 Broadband (BE725BB-TU)...

1 Answer

Slow working


you need to run the disk clean up in order to speed up your system, you also need to run a registry cleaner to speed up from booting, you can also upgrade the ram memory to speed up. you can also need to to run the defragmentation at least weekly. these are the solutions you need to speed up your system, you can choose either one of them

Nov 28, 2007 | Computers & Internet

3 Answers

WINDOWS MEDIA PLAYER NOT RESPONDING..


Windows Media Player in this case has a script error that causes it not to respond on any OS platform that has yet to be fixed by updates. I have currently updated it to its fullest and it refuses to respond properly on windows xp, let alone beta versions of windows like windows 7. My suggestion is forget windows media player 11 and go download VLC player which plays more things off the bat anyways. Its free and easy and small. There is also any number of other media players like Realplayer, Quicktime, or Windows Media Player Classic. 

Sep 15, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

405 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98796 Answers

David Payne
David Payne

Level 3 Expert

14071 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...