Thread
:
Excel : F2-F4 in multiple sheets should have independent result
View Single Post
#
2
Posted to microsoft.public.excel.misc
Nick Hodge
external usenet poster
Posts: 1,173
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
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge