ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 Slow Function Argument Window (https://www.excelbanter.com/excel-discussion-misc-queries/32465-excel-2003-slow-function-argument-window.html)

[email protected]

Excel 2003 Slow Function Argument Window
 
I've just installed Excel 2003 at home. When I select a function in the
Insert Function dialog, it takes FOREVER for the Function Arguments
window to appear.

The Arguments windows is animated to appear to pop up from under the
formula bar. I can count the seconds watching the animation of the box
appearing, and it's so annoying. In Excel 2000 I could have already
completed entering the arguements by the time the window comes up. None
of the other menus appear to be slow. I've tried looking for a way to
turn off menu animations both in Excel and Windows in general and
nothing seems to help. Any tips would be greatly appreciated.

I have a reasonably fast computer and video card, and plently of
memory.

Thanks,
Dave


Dave Peterson

I don't have a guess. It took a bit longer (not quite forever when I did it).

But if I type the function instead of relying on the Fx button, it seems to work
quicker.

So typing =Vlookup( then hitting the Fx button is quicker (or hit ctrl-a here)

You may also be able to get by with a little less help:

=vlookup(
Then hit shift-ctrl-a. You'll see a some function tips that may suffice.



wrote:

I've just installed Excel 2003 at home. When I select a function in the
Insert Function dialog, it takes FOREVER for the Function Arguments
window to appear.

The Arguments windows is animated to appear to pop up from under the
formula bar. I can count the seconds watching the animation of the box
appearing, and it's so annoying. In Excel 2000 I could have already
completed entering the arguements by the time the window comes up. None
of the other menus appear to be slow. I've tried looking for a way to
turn off menu animations both in Excel and Windows in general and
nothing seems to help. Any tips would be greatly appreciated.

I have a reasonably fast computer and video card, and plently of
memory.

Thanks,
Dave


--

Dave Peterson

[email protected]

Thanks,

The Ctrl-Shift-a trick will help ease the pain.

Dave Peterson wrote:
I don't have a guess. It took a bit longer (not quite forever when I did it).

But if I type the function instead of relying on the Fx button, it seems to work
quicker.

So typing =Vlookup( then hitting the Fx button is quicker (or hit ctrl-a here)

You may also be able to get by with a little less help:

=vlookup(
Then hit shift-ctrl-a. You'll see a some function tips that may suffice.



wrote:

I've just installed Excel 2003 at home. When I select a function in the
Insert Function dialog, it takes FOREVER for the Function Arguments
window to appear.

The Arguments windows is animated to appear to pop up from under the
formula bar. I can count the seconds watching the animation of the box
appearing, and it's so annoying. In Excel 2000 I could have already
completed entering the arguements by the time the window comes up. None
of the other menus appear to be slow. I've tried looking for a way to
turn off menu animations both in Excel and Windows in general and
nothing seems to help. Any tips would be greatly appreciated.

I have a reasonably fast computer and video card, and plently of
memory.

Thanks,
Dave


--

Dave Peterson




All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com