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

-gem

"Miguel Zapico" wrote:

The cause may be that the workbook was set to manual calculation somehow.
Check it on Tools - Options - 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.

"jcoleman52" wrote:


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 "[Group]" 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 "New" 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: http://www.excelforum.com/member.php...o&userid=29498
View this thread: http://www.excelforum.com/showthread...hreadid=535568