View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ronald Dodge[_2_] Ronald Dodge[_2_] is offline
external usenet poster
 
Posts: 130
Default finding a file in excel

I have seen that happen in XL97, XL2000, and XL2002, but can't say for
XL2003 or later.

Even though I have used earlier versions of Excel, but I never did use Excel
extensively until Excel 97, which I hated Excel 97 cause of all the
different issues that I ran into with Excel 97. As far as that's concerned,
I would have rather worked with Lotus 1-2-3, V2.3 than Excel 97, SR-2. It
was only when I started working with Excel 2000 (which was sent to me free
of charge as a fix to a charting bug in Excel 97, SR-2), did I find Excel
finally easier to work with than Lotus 1-2-3 v2.3 Lotus 1-2-3 v2.3 is a DOS
program, which may be a bit tough to work with in some ways on a system that
still uses DOS, but at least it was a relatively stable program.

Two of the issues that I had to contend with in Excel 97, SR-2 we

When dividing the sum of one range greater than 25 rows by the sum of
another range greater than 25 rows, it would return the result as "1/0"

When using charts, no matter what setting was used on the legend, the legend
would gradually work it's way from the position it was set at to the top
center portion of the chart. That was during the days when my VBA knowledge
was very limited.

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Ronald

Incorrect information on later versions.

Excel stores all Menu and Toolbar customizations in the *.XLB file.

I believe you are thinking of pre-xl97 when Excel had the old menu editor
and
stored the customizations in Personal.xls


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 16:19:12 -0400, "Ronald Dodge"

wrote:

By default, Excel stores any custom toolbars in the Personal.xls workbook,
which is stored under the general startup folder that any user can get to.
This workbook is also generally hidden as it's hidden by default.
However,
the user can attach such toolbars to other workbooks.