Easy one first...

I think that this is one of those settings that's stored in the windows
registry. If your changes aren't being saved, it may be worthwhile to talk to
your IT folks to find out why you can't save to the registry.

Maybe you're not an administrator for your pc (or you're logged on as a user who
doesn't have those rights).

But until you get it fixed, you could put a workbook in your XLStart folder.
That means the workbook will open each time you start excel.

The code could turn the setting off and close the workbook.

Option Explicit
Sub auto_open()
Application.EditDirectlyInCell = True
ThisWorkbook.Close savechanges:=False
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

The more difficult question...

#1. Are you sure the formulas all look the same? Maybe the formulas are
different, but the formulas have recalculated (yet). Tools|Options|Calculation
tab. (Make sure Automatic is checked.)



chande00 wrote:

Hi, I have two issues that I've run into with Excel that have me stumped.

1) I am trying to mirror a row of values (via formulas) from one sheet to
another. I do not want to simply cut and paste b/c I am udating the sheets.
Typically I copy one cell and then drag it across the row to fill in the
remaining cells. Right now, however, the worksheet is simply repeating the
same value instead of inputting 'value + 1 (column)'.

Ex. I want to have a mirror of cells B2-B6 so I input on the new sheet, C5
= 'Orig. Sheet'B2. I then drag the corner of C5 across the row to try to
fill in with B3, B4, B5, B6 from the original sheet....Instead what I'm
getting is B2, B2, B2, B2.....

Any idea what setting might have changed or how to get it back to the way I
would prefer?

That leads me to my second question which is more of a general Excel
question...

2) Excel seems to sometimes change settings when I open and close it. For
instance, I always prefer to "edit directly in cell", however, many times I
will have to click this check box each time I open a file (even the same one
that's been saved the other way). I am confused as to why it keeps
defaulting back to a setting and forces me to manually change it. Is it
possible that there is a bug in my version of the program?

Thanks for any ideas.

--

Dave Peterson