J
John H
Hi. Our users have recently upgraded from office 2000 to Office 2007. One
has to get a set of totals from one workbook into another. He is finding
that if he has two workbooks open, deletes some data from Workbook1 to get
the totals he needs and pastes or manually types the result into workbook2 ,
goes back to workbook1 and hits Undo to restore the full source data, the
undo is applied to the data he has just typed in Workbook2. The next undo
restores the data in workbook1 but then he has lost his total.
Excel seems to be applying the undo to the last change made regardless of
which worksheet he is in at the time.
I loked on my machine and I have four excel spreadsheets open; on one of
these, looking in Excel Options, Advanced and at the "When Calculating this
workbook" option gives a drop-down list containing two of the workbooks. If
I go into a different workbook (not one of the two listed) the same drop-down
box there only shows one workbook. I guess this related to our user's
problem but I don't know how.
Is there a way of controlling which workbooks are grouped in this way? I
haven't done anything to group them that I'm aware of.
With thanks in anticipation,
John H.
has to get a set of totals from one workbook into another. He is finding
that if he has two workbooks open, deletes some data from Workbook1 to get
the totals he needs and pastes or manually types the result into workbook2 ,
goes back to workbook1 and hits Undo to restore the full source data, the
undo is applied to the data he has just typed in Workbook2. The next undo
restores the data in workbook1 but then he has lost his total.
Excel seems to be applying the undo to the last change made regardless of
which worksheet he is in at the time.
I loked on my machine and I have four excel spreadsheets open; on one of
these, looking in Excel Options, Advanced and at the "When Calculating this
workbook" option gives a drop-down list containing two of the workbooks. If
I go into a different workbook (not one of the two listed) the same drop-down
box there only shows one workbook. I guess this related to our user's
problem but I don't know how.
Is there a way of controlling which workbooks are grouped in this way? I
haven't done anything to group them that I'm aware of.
With thanks in anticipation,
John H.