Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This question already has an answer here:

I'm trying to get the sheet name into a cell. I've tried using:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

but my Excel 2003 displays an error when I try to enter the formula. Why is that?

enter image description here

Could it be because it's excel 2003?

share|improve this question

marked as duplicate by Karan, Canadian Luke, Tog, Scott, Brad Patton Apr 11 '13 at 0:59

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
To isolate which part of your formula is causing the error, try typing "=CELL("filename", A1)" into another cell. –  Ellesa Apr 7 '13 at 17:31
    
that part already gives error =CELL("filename", A1) –  FernandoSBS Apr 7 '13 at 19:04
    
@kaze: it seems that EVERY formula that I past is giving me error when it has a "," could that be related to my region being Brazil, or something like that? Or is it necessary to reinstall excel? It really sucks, every formula gives errors in the ",". Is it a problem with excel 2003? –  FernandoSBS Apr 7 '13 at 19:58
    
Yeah, that was the problem, I must use ";" and not "," between arguments, probably because of some region settings. –  FernandoSBS Apr 7 '13 at 21:07

1 Answer 1

An internal sheet reference would look like: Annual!A1:A10 (where Annual is the sheet name obviously).

An external sheet reference would look like: 'C:\Reports[Budget.xlsx]Annual'!A1:A10

Source

share|improve this answer
    
I believe you but not that this answers the OP. –  pnuts Apr 10 '13 at 16:04
1  
@pnuts: His problem turned out to be something else entirely, i.e. his regional settings caused the list separator on his system to be a semicolon instead of a comma, as he found via a later question. My answer is correct in terms of the info it provides, just that the OP had another problem entirely. –  Karan Apr 10 '13 at 17:04

Not the answer you're looking for? Browse other questions tagged or ask your own question.