Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 44
Default =CELL("filename") returns #VALUE!

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,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 834
Default =CELL("filename") returns #VALUE!

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

"SupperDuck" wrote in message
...
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,



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default =CELL("filename") returns #VALUE!

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
wrote:

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,


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default =CELL("filename") returns #VALUE!

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" 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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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,


.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 834
Default =CELL("filename") returns #VALUE!

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


"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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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,


.





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default =CELL("filename") returns #VALUE!

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


"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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default =CELL("filename") returns #VALUE!

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


"Dave Peterson" wrote:

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


"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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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
.

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default =CELL("filename") returns #VALUE!

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

On Thu, 8 Apr 2010 07:57:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

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


"Dave Peterson" wrote:

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


"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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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
.


  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default =CELL("filename") returns #VALUE!

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" wrote:

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

On Thu, 8 Apr 2010 07:57:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

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


"Dave Peterson" wrote:

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


"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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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
.


.

  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default =CELL("filename") returns #VALUE!

Make sure you recalc.

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

????? (????) ????? wrote:

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" wrote:

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

On Thu, 8 Apr 2010 07:57:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

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


"Dave Peterson" wrote:

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


"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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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
.


.


--

Dave Peterson


  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default =CELL("filename") returns #VALUE!

Much obliged.
Micky


"Dave Peterson" wrote:

Make sure you recalc.

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

????? (????) ????? wrote:

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" wrote:

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

On Thu, 8 Apr 2010 07:57:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

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


"Dave Peterson" wrote:

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


"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 Wed, 7 Apr 2010 13:19:01 -0700, SupperDuck
wrote:

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
.


.


--

Dave Peterson
.

  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default =CELL("filename") returns #VALUE!

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

=CELL("FILENAME")

On Wednesday, April 07, 2010 4:19 PM SupperDuck wrote:


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



On Thursday, April 08, 2010 8:05 AM Dave Peterson wrote:


Just to add to Bob's response...

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:

--

Dave Peterson



On Thursday, April 08, 2010 10:57 AM ????? (????) ????? wrote:


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


"Dave Peterson" wrote:



On Thursday, April 08, 2010 11:14 AM Gord Dibben wrote:


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

<micky-a*at*tapuz.co.il wrote:



On Thursday, April 08, 2010 12:19 PM ????? (????) ????? wrote:


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" 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:




  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default =CELL("filename") returns #VALUE!

Thanks Cem İspir.
It was big problem.
=CELL("FILENAME") perfectcly worked.
  #14   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default =CELL("filename") returns #VALUE!

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

Cheers!
Bahadir.

On Tuesday, July 19, 2011 at 8:59:18 PM UTC+3, cem ispir wrote:
This I think is unique to Excel with Turkish related environments, just try filename keywork in uppercase like:

=CELL("FILENAME")

On Wednesday, April 07, 2010 4:19 PM SupperDuck wrote:


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



On Thursday, April 08, 2010 8:05 AM Dave Peterson wrote:


Just to add to Bob's response...

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:

--

Dave Peterson



On Thursday, April 08, 2010 10:57 AM ????? (????) ????? wrote:


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


"Dave Peterson" wrote:



On Thursday, April 08, 2010 11:14 AM Gord Dibben wrote:


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

<micky-a*at*tapuz.co.il wrote:



On Thursday, April 08, 2010 12:19 PM ????? (????) ????? wrote:


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" 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:

  #15   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default =CELL("filename") returns #VALUE!

Thanks Cem İspir. i am much obliged!


  #16   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default =CELL("filename") returns #VALUE!

Thanks Cem . İt is working ...

Erdal
Reply
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
CELL("filename") doesn't work on shortcut workbook link? Kevin Excel Worksheet Functions 12 February 6th 10 08:33 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION yossie6 Excel Discussion (Misc queries) 1 June 16th 08 12:16 PM
Cell("filename") doesn't update to new filename when do save as. Louis Excel Worksheet Functions 2 March 22nd 07 08:27 PM
CELL("filename") acting Volatile? (in assoc. with PULL) [email protected] Excel Worksheet Functions 4 August 3rd 06 03:23 PM


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

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

About Us

"It's about Microsoft Excel"