Excel : F2-F4 in multiple sheets should have independent result
 

How extremely lame. A 'relative' action such as F2-F4 (toggle
relative/absolute cell references), on a cell across multiple highlighted
sheets, results in all sheets having the result from the current sheet.

Do kindergarten children programme for MS, because this is so inept it isn't
funny.

eg. If, 'Sheet 1'!C45 = M55 and 'Sheet 2'!C45 = B23

then after F2, F4 the results should be $M$55 and $B$23, NOT $M$55 for both.

Use your brains that God gave you guys,... this is so obvious!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Excel : F2-F4 in multiple sheets should have independent result
 

As I suspect you are 'grouping' the sheets. The functionality has always
been that anything done on the 'edited' sheet was precisely 'mirrored' on
the other grouped sheets.

I think the model looks at the reasons that most people want to 'group'
sheets, which would be to set up identical sheets, say for months of the
year, etc. In this way all formula would point to the same cell and the
functionality would be ok as designed.

Am I missing something?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"themantheworldlovesmorethannathan"
rosoft.com wrote in
message ...
How extremely lame. A 'relative' action such as F2-F4 (toggle
relative/absolute cell references), on a cell across multiple highlighted
sheets, results in all sheets having the result from the current sheet.

Do kindergarten children programme for MS, because this is so inept it
isn't
funny.

eg. If, 'Sheet 1'!C45 = M55 and 'Sheet 2'!C45 = B23

then after F2, F4 the results should be $M$55 and $B$23, NOT $M$55 for
both.

Use your brains that God gave you guys,... this is so obvious!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc