Relative references in Excel defined names

[UKenGB]

In regular Excel, you can use relative references when defining a Name, so the 'Named' formula can be used in different places and use data from different sources (but the same 'relative' to the target cell). But in Excel Mobile, this doesn't seem to work. A simple reference such as B3 is always B3 wherever the name is used, just as if it was $B$3, IOW an absolute reference.

Does anyone know if this is a (very serious) limitation of Excel Mobile or is there really a way to use relative references in names and I'm simply not doing it right?

BTW, this is using Windows Mobile 6 on an Orbit 2.

Thanks.

[The Mailman]

Not my fiield of knowledge but have you tried creating a simple PC version of what you want and then opening it on your mobile to see what it does/does not do?

[windows]

I may be wrong but I think a third party spreadsheet application such as pTAB will handle this for you.

[cyclist]

Not sure if this is what you are after.
I have created cell forumlas like in cell B1 =A1+7 where A1 and B1 are both date type. I can then copy and paste the B1 cell down the B column. Excel automatically changes the formula for the row that I paste to. So if I paste from B1 to B52 then B52 gets a formula that is =A52+7.
I have some formulas set up with $ in for absolute references and they seem to work as well.
Don't know if it has any significance, but the originals of these spreadsheets were created a long time ago on a different version of Windows Mobile. The edits I'm talking about were made on PPC.

[UKenGB]

As you say, it works for 'in cell' formulas. But if you define a 'name' that contains a formula, any cell references act as absolute refs, even when not specified as such, whereas it all works correctly on full size Excel.

[windows]

It should work with names in pTAB too

[jackgopher]

I have the latest version of Excel mobile, and relative references in named formulas don't work.....



____________
Relative reference