Just to add.

You saw that your values for Option3 varied from both Gord's and mine.

Option3 holds more than this one setting. So you want to be a little careful!

cmart02 wrote:

I managed to figure it out!!

Dave, thanks for the tip. I went to the Registry and found where the option
was! I played with it and got it eventually. Have suggested this to my friend
but still don't know what happened... I will post in case of goods news
(whether on the "Write Access" or not)

For those who do not know:

1) Start -- Run
2) Type: regedit
3) Hit "enter"

Expand as follows:

1) HKEY_CURRENT_USER
2) Software
3) Microsoft
4) Office (your version, mine is 10.0)
5) Excel
6) Options
7) Double-click on Option3 - REG_DWORD (right-hand side of box)

Change value from 3 to 40

I don't know if these values apply for all versions of Excel, though, but it
worked fine for me.

--

Dave Peterson