software

Hello:

I had very unusual experience with Excel this morning. I had set up a
workbook last week to do some calculations, and I opened it up this
morning to continue my work. I wanted to copy a formula from one cell
to others in the same column. I used the same procedure I had used a
million times before - selected the object cell, hit crtl-C to copy,
then selected the target cell(s), and finally, hit ctrl-V to copy the
formulas. Well it seemed to copy them correctly, the cell references
all changed appropriately for the copied cells, but the results were
not correct. The result for all the cells was the result for the
original cell, just copied over and over again, even though the
formulas appeared to address different cells with different values. A
little additional info: 1) When setting up the workbook, I had tried
to insert multiple worksheets at once instead of just inserting one at
a time, as I had always done previously, and 2) When opening the
workbook this morning, in the header above the toolbar, where the
workbook name appears, there was a notation quot;[Group]quot; after the name,
which I had never seen before. I shut down Excel and re-opened the
workbook, thinking that I had inadvertently hit a strange key
combination on opening, but that didn't work. I shut down and rebooted
my PC, but that didn't work. Finally, after I opened up a blank sheet
as a quot;Newquot; workbook, entered some data and did the ctrl-C, crtl-V
sequence, it seemed to reset everything to work as expected. Weird.
Any ideas? Thanks alot.--
jcoleman52
------------------------------------------------------------------------
jcoleman52's Profile: www.excelforum.com/member.php...oamp;userid=29498
View this thread: www.excelforum.com/showthread...hreadid=535568The cause may be that the workbook was set to manual calculation somehow.
Check it on Tools -gt; Options -gt; Calculation.
You can also check it by pressing F9 after you did the copy/paste, if that
was the cause the data should change after that.

quot;jcoleman52quot; wrote:

gt;
gt; Hello:
gt;
gt; I had very unusual experience with Excel this morning. I had set up a
gt; workbook last week to do some calculations, and I opened it up this
gt; morning to continue my work. I wanted to copy a formula from one cell
gt; to others in the same column. I used the same procedure I had used a
gt; million times before - selected the object cell, hit crtl-C to copy,
gt; then selected the target cell(s), and finally, hit ctrl-V to copy the
gt; formulas. Well it seemed to copy them correctly, the cell references
gt; all changed appropriately for the copied cells, but the results were
gt; not correct. The result for all the cells was the result for the
gt; original cell, just copied over and over again, even though the
gt; formulas appeared to address different cells with different values. A
gt; little additional info: 1) When setting up the workbook, I had tried
gt; to insert multiple worksheets at once instead of just inserting one at
gt; a time, as I had always done previously, and 2) When opening the
gt; workbook this morning, in the header above the toolbar, where the
gt; workbook name appears, there was a notation quot;[Group]quot; after the name,
gt; which I had never seen before. I shut down Excel and re-opened the
gt; workbook, thinking that I had inadvertently hit a strange key
gt; combination on opening, but that didn't work. I shut down and rebooted
gt; my PC, but that didn't work. Finally, after I opened up a blank sheet
gt; as a quot;Newquot; workbook, entered some data and did the ctrl-C, crtl-V
gt; sequence, it seemed to reset everything to work as expected. Weird.
gt; Any ideas? Thanks alot.
gt;
gt;
gt; --
gt; jcoleman52
gt; ------------------------------------------------------------------------
gt; jcoleman52's Profile: www.excelforum.com/member.php...oamp;userid=29498
gt; View this thread: www.excelforum.com/showthread...hreadid=535568
gt;
gt;

The quot;[Group]quot; notation was because you had multiple sheets (tabs) selected.
Right click one of the tabs and select Ungroup Sheets.

-gem

quot;Miguel Zapicoquot; wrote:

gt; The cause may be that the workbook was set to manual calculation somehow.
gt; Check it on Tools -gt; Options -gt; Calculation.
gt; You can also check it by pressing F9 after you did the copy/paste, if that
gt; was the cause the data should change after that.
gt;
gt; quot;jcoleman52quot; wrote:
gt;
gt; gt;
gt; gt; Hello:
gt; gt;
gt; gt; I had very unusual experience with Excel this morning. I had set up a
gt; gt; workbook last week to do some calculations, and I opened it up this
gt; gt; morning to continue my work. I wanted to copy a formula from one cell
gt; gt; to others in the same column. I used the same procedure I had used a
gt; gt; million times before - selected the object cell, hit crtl-C to copy,
gt; gt; then selected the target cell(s), and finally, hit ctrl-V to copy the
gt; gt; formulas. Well it seemed to copy them correctly, the cell references
gt; gt; all changed appropriately for the copied cells, but the results were
gt; gt; not correct. The result for all the cells was the result for the
gt; gt; original cell, just copied over and over again, even though the
gt; gt; formulas appeared to address different cells with different values. A
gt; gt; little additional info: 1) When setting up the workbook, I had tried
gt; gt; to insert multiple worksheets at once instead of just inserting one at
gt; gt; a time, as I had always done previously, and 2) When opening the
gt; gt; workbook this morning, in the header above the toolbar, where the
gt; gt; workbook name appears, there was a notation quot;[Group]quot; after the name,
gt; gt; which I had never seen before. I shut down Excel and re-opened the
gt; gt; workbook, thinking that I had inadvertently hit a strange key
gt; gt; combination on opening, but that didn't work. I shut down and rebooted
gt; gt; my PC, but that didn't work. Finally, after I opened up a blank sheet
gt; gt; as a quot;Newquot; workbook, entered some data and did the ctrl-C, crtl-V
gt; gt; sequence, it seemed to reset everything to work as expected. Weird.
gt; gt; Any ideas? Thanks alot.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; jcoleman52
gt; gt; ------------------------------------------------------------------------
gt; gt; jcoleman52's Profile: www.excelforum.com/member.php...oamp;userid=29498
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=535568
gt; gt;
gt; gt;


Thanks, guys. Both replies were right on the money. I changed to
manual calculations and the phenomenon repeated itself. I changed back
and everything calculated correctly.

A also checked out the group/ungroup thing, and that was as you said it
would be.

I don't know how the manual calculation switch got turned on, or how I
turned it off earlier, but...all's well that ends well.

Thanks again.
gem Wrote:
gt; The quot;[Group]quot; notation was because you had multiple sheets (tabs)
gt; selected.
gt; Right click one of the tabs and select Ungroup Sheets.
gt;
gt; -gem
gt;
gt; quot;Miguel Zapicoquot; wrote:
gt;
gt; gt; The cause may be that the workbook was set to manual calculation
gt; somehow.
gt; gt; Check it on Tools -gt; Options -gt; Calculation.
gt; gt; You can also check it by pressing F9 after you did the copy/paste, if
gt; that
gt; gt; was the cause the data should change after that.
gt; gt;
gt; gt; quot;jcoleman52quot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; Hello:
gt; gt; gt;
gt; gt; gt; I had very unusual experience with Excel this morning. I had set
gt; up a
gt; gt; gt; workbook last week to do some calculations, and I opened it up
gt; this
gt; gt; gt; morning to continue my work. I wanted to copy a formula from one
gt; cell
gt; gt; gt; to others in the same column. I used the same procedure I had used
gt; a
gt; gt; gt; million times before - selected the object cell, hit crtl-C to
gt; copy,
gt; gt; gt; then selected the target cell(s), and finally, hit ctrl-V to copy
gt; the
gt; gt; gt; formulas. Well it seemed to copy them correctly, the cell
gt; references
gt; gt; gt; all changed appropriately for the copied cells, but the results
gt; were
gt; gt; gt; not correct. The result for all the cells was the result for the
gt; gt; gt; original cell, just copied over and over again, even though the
gt; gt; gt; formulas appeared to address different cells with different values.
gt; A
gt; gt; gt; little additional info: 1) When setting up the workbook, I had
gt; tried
gt; gt; gt; to insert multiple worksheets at once instead of just inserting one
gt; at
gt; gt; gt; a time, as I had always done previously, and 2) When opening the
gt; gt; gt; workbook this morning, in the header above the toolbar, where the
gt; gt; gt; workbook name appears, there was a notation quot;[Group]quot; after the
gt; name,
gt; gt; gt; which I had never seen before. I shut down Excel and re-opened
gt; the
gt; gt; gt; workbook, thinking that I had inadvertently hit a strange key
gt; gt; gt; combination on opening, but that didn't work. I shut down and
gt; rebooted
gt; gt; gt; my PC, but that didn't work. Finally, after I opened up a blank
gt; sheet
gt; gt; gt; as a quot;Newquot; workbook, entered some data and did the ctrl-C, crtl-V
gt; gt; gt; sequence, it seemed to reset everything to work as expected.
gt; Weird.
gt; gt; gt; Any ideas? Thanks alot.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; jcoleman52
gt; gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gt; jcoleman52's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29498
gt; gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=535568
gt; gt; gt;
gt; gt; gt;--
jcoleman52
------------------------------------------------------------------------
jcoleman52's Profile: www.excelforum.com/member.php...oamp;userid=29498
View this thread: www.excelforum.com/showthread...hreadid=535568