=CELL("filename") returns #VALUE!

S

SupperDuck

Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,
 
B

Bob Phillips

Presumably you need to use the Turkish equivalent of "filename" in that
formula. I have no idea what that might be, but if you have Turkish help,
try looking up 'CELL function' in help, the info_type is listed there,
hopefully it will give you your equivalent.
 
G

Gord Dibben

After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP
 
×

מיכ×ל (מיקי) ×בידן

To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky
 
B

Bob Phillips

You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

????? (????) ????? said:
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky


Gord Dibben said:
After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP



.
 
D

Dave Peterson

Just to add to Bob's response...

Try opening two files (so that they've been saved). Then make a new window and
make sure that each window shows a sheet from a different workbook.

Then try each of the formulas (with the cell reference and without the cell
reference) and recalculate.

You'll see the problem (or feature if that's actually want you want <vbg>).

Bob said:
You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

????? (????) ????? said:
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky


Gord Dibben said:
After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck

Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,

.
 
×

מיכ×ל (מיקי) ×בידן

Thanks.
Every day I learn somethig new...
Micky


Dave Peterson said:
Just to add to Bob's response...

Try opening two files (so that they've been saved). Then make a new window and
make sure that each window shows a sheet from a different workbook.

Then try each of the formulas (with the cell reference and without the cell
reference) and recalculate.

You'll see the problem (or feature if that's actually want you want <vbg>).

Bob said:
You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

????? (????) ????? said:
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky


:

After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck

Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,

.
 
G

Gord Dibben

In addition..............

=CELL("filename")

Returns not just workbook name but full path including sheetname.

So the incorrect results will occur even in a single workbook.


Gord

Thanks.
Every day I learn somethig new...
Micky


Dave Peterson said:
Just to add to Bob's response...

Try opening two files (so that they've been saved). Then make a new window and
make sure that each window shows a sheet from a different workbook.

Then try each of the formulas (with the cell reference and without the cell
reference) and recalculate.

You'll see the problem (or feature if that's actually want you want <vbg>).

Bob said:
You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

"????? (????) ?????" <micky-a*at*tapuz.co.il> wrote in message
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky


:

After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck

Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,

.
 
×

מיכ×ל (מיקי) ×בידן

I just typed: =CELL("filename") in sheet1 of a previous saved WB.
I copied it to sheet2 and upon switching between those 2 sheets I dont get
any error and/or a different result.
What am I doing wrong here ?
Micky


Gord Dibben said:
In addition..............

=CELL("filename")

Returns not just workbook name but full path including sheetname.

So the incorrect results will occur even in a single workbook.


Gord

Thanks.
Every day I learn somethig new...
Micky


Dave Peterson said:
Just to add to Bob's response...

Try opening two files (so that they've been saved). Then make a new window and
make sure that each window shows a sheet from a different workbook.

Then try each of the formulas (with the cell reference and without the cell
reference) and recalculate.

You'll see the problem (or feature if that's actually want you want <vbg>).

Bob Phillips wrote:

You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

"????? (????) ?????" <micky-a*at*tapuz.co.il> wrote in message
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky


:

After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck

Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,

.

.
 
D

Dave Peterson

Make sure you recalc.

And it's easier to see if you have two windows open, too.

????? (????) ????? said:
I just typed: =CELL("filename") in sheet1 of a previous saved WB.
I copied it to sheet2 and upon switching between those 2 sheets I dont get
any error and/or a different result.
What am I doing wrong here ?
Micky

Gord Dibben said:
In addition..............

=CELL("filename")

Returns not just workbook name but full path including sheetname.

So the incorrect results will occur even in a single workbook.


Gord

Thanks.
Every day I learn somethig new...
Micky


:

Just to add to Bob's response...

Try opening two files (so that they've been saved). Then make a new window and
make sure that each window shows a sheet from a different workbook.

Then try each of the formulas (with the cell reference and without the cell
reference) and recalculate.

You'll see the problem (or feature if that's actually want you want <vbg>).

Bob Phillips wrote:

You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

"????? (????) ?????" <micky-a*at*tapuz.co.il> wrote in message
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky


:

After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck

Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,

.

.
 
×

מיכ×ל (מיקי) ×בידן

Much obliged.
Micky


Dave Peterson said:
Make sure you recalc.

And it's easier to see if you have two windows open, too.

????? (????) ????? said:
I just typed: =CELL("filename") in sheet1 of a previous saved WB.
I copied it to sheet2 and upon switching between those 2 sheets I dont get
any error and/or a different result.
What am I doing wrong here ?
Micky

Gord Dibben said:
In addition..............

=CELL("filename")

Returns not just workbook name but full path including sheetname.

So the incorrect results will occur even in a single workbook.


Gord

Thanks.
Every day I learn somethig new...
Micky


:

Just to add to Bob's response...

Try opening two files (so that they've been saved). Then make a new window and
make sure that each window shows a sheet from a different workbook.

Then try each of the formulas (with the cell reference and without the cell
reference) and recalculate.

You'll see the problem (or feature if that's actually want you want <vbg>).

Bob Phillips wrote:

You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

"????? (????) ?????" <micky-a*at*tapuz.co.il> wrote in message
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I'm wrong.
Micky


:

After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck

Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,

.


--

Dave Peterson
.


.
 
B

baho81

Thanks Cem. I am also using English Excel but rest of the software and regional settings are Turkish. =CELL("FILENAME") works fine.

Cheers!
Bahadir.

This I think is unique to Excel with Turkish related environments, just try filename keywork in uppercase like:

=CELL("FILENAME")
Dear Friends,

When I use =CELL("filename") in Turkish regional style, it gives #VALUE!
error but if I change the settings to USA, it works!

Why? And how I can solve this ?

PS: I use an english office 2007 and I use the formulas in English, no
problem with any of them. But I got error with this.

Thanks & Regards,
On Wednesday, April 07, 2010 5:22 PM Bob Phillips wrote:
Presumably you need to use the Turkish equivalent of "filename" in that
formula. I have no idea what that might be, but if you have Turkish help,
try looking up 'CELL function' in help, the info_type is listed there,
hopefully it will give you your equivalent.

--

HTH

Bob
On Wednesday, April 07, 2010 6:07 PM Gord Dibben wrote:
After you have found the Turkish equivalent to "filename" change your
formula slightly.

=CELL("filename",A1)

Elsewise you can get wierd results when you switch sheets back and forth.


Gord Dibben MS Excel MVP
On Thursday, April 08, 2010 3:38 AM ????? (????) ????? wrote:
To the best of my knowledge, "filename" returns the WB name and as such it
will not cause any problem without using the A1.
However,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31) returns the
ONLY SHEETS NAME and therefor needs the A1.
please, correct me if I am wrong.
Micky


"Gord Dibben" wrote:
On Thursday, April 08, 2010 5:40 AM Bob Phillips wrote:
You are wrong.

If you have two workbooks open and that formula in WB1, if a full recalc
happens whilst WB2 is open, the formula will update and point at the wrong
workbook.

--

HTH

Bob

"????? (????) ?????" <micky-a*at*tapuz.co.il> wrote in message
Try opening two files (so that they have been saved). Then make a new window and
make sure that each window shows a sheet from a different workbook.

Then try each of the formulas (with the cell reference and without the cell
reference) and recalculate.

You'll see the problem (or feature if that is actually want you want <vbg>).

Bob Phillips wrote:
On Thursday, April 08, 2010 10:57 AM ????? (????) ????? wrote:
Thanks.
Every day I learn somethig new...
Micky


"Dave Peterson" wrote:
...........

=CELL("filename")

Returns not just workbook name but full path including sheetname.

So the incorrect results will occur even in a single workbook.


Gord

<micky-a*at*tapuz.co.il> wrote:
=CELL("filename") in sheet1 of a previous saved WB.
I copied it to sheet2 and upon switching between those 2 sheets I dont get
any error and/or a different result.
What am I doing wrong here ?
Micky


"Gord Dibben" wrote:
On Thursday, April 08, 2010 1:12 PM Dave Peterson wrote:
Make sure you recalc.

And it is easier to see if you have two windows open, too.

????? (????) ????? wrote:
On Thursday, April 08, 2010 2:13 PM ????? (????) ????? wrote:
Much obliged.
Micky


"Dave Peterson" wrote:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top