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: 12
Default Table function, 2 variables. Problem with update/refresh

Hi all!
i build a table that seems to work properly.

On the vertical axis i have 3 values and 5 on the horizontal.
No problems at all.

BUT
if i want to change 1 of the 3 values on the axis some weird happens.

if i link 1 value on the axis (let's say the middle value on the
vertical axis)
to another cell, the table updates, but with wrong values.
Instead if I TYPE the new value (exactly the same value) the table is
update properly.

It seems that the difference is not the number shown on the axis, but
the way i put it in the cell: if a create a reference to another cell,
doesn't work. If i write in the same value i see in the cell i want to
reference, no problem.
I tried to press F9 to update, but the result doesn't change.

i don't know if i have been clear...
thanks in advance

 
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
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
Mid Function Problem DEI Excel Discussion (Misc queries) 3 August 9th 06 08:08 PM
VBA Function that ignores dates in a Holiday Table Sorbit Excel Worksheet Functions 0 January 17th 06 10:03 PM
function defaults change in Pivot Table..why? Jugglertwo Excel Discussion (Misc queries) 2 September 23rd 05 07:10 PM
Solver problem where 'IF Function' is bad David Adamson Excel Discussion (Misc queries) 5 September 23rd 05 06:10 AM


All times are GMT +1. The time now is 11:25 PM.

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"