LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Strange behavior when calculate two or more cells

Hi there,

I know that most of you won't believe that the following situation is true
but it is !!
I have about 50 users with typical Excel 2007 sp1 installation. No strange
add-ins or anything similar.

Some of them when they try the very simple action to add or multiply etc
cells from another sheet and return the result to the current one, they don't
get what they expect.

To be specific: Suppose that i am in sheet2!A5 cell. I am typing "=" and
move to sheet1. I choose cell B4 (i see the value on the formula bar) i type,
let's say, "+" and choose cell C3. After that i press enter.

The normal would be to return in sheet2!A5 cell the result of the formula
Sheet1B4+sheet1C3. Well it doesn't. The formula and the result are entered in
the A5 cell of sheet1 and nothing in sheet2.

That's very weird and i'd appreciate a hint soon.

Thanks and regards

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange behavior Ritchie Excel Discussion (Misc queries) 2 September 26th 06 02:21 AM
Strange behavior for AutoFilter 1scant Excel Discussion (Misc queries) 0 March 2nd 06 08:49 PM
Excel Mac OS X - Strange Behavior BrianP Excel Discussion (Misc queries) 0 January 1st 06 08:07 AM
Strange behavior DeRussie Setting up and Configuration of Excel 4 November 26th 05 05:41 PM
Strange behavior. Wiley Coyote Excel Discussion (Misc queries) 7 October 18th 05 04:35 PM


All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"