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

[themantheworldlovesmorethannathan]

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

[Nick Hodge]

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"themantheworldlovesmorethannathan"
<themantheworldlovesmorethannathan@discussions.microsoft.com> wrote in
message news:99C73380-9FEB-4196-987B-0A505B045AF5@microsoft.com...
> 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