AnsweredAssumed Answered

Excel range names not recognized ... huh?

Question asked by synergy46 on Feb 28, 2014
Latest reply on Feb 28, 2014 by synergy46

I was successfully importing an Excel v 11 file into my FM data then I discovered that Excel allows for the creation of 'dynamic' range names. Kewl!

 

So, I change my Excel range definition to =OFFSET(INFO!$R$12,0,0,COUNTA(INFO!$R$12:INFO!$AD$612),13) and suddenly FM 13 does not recognize my ranges?

 

Yes, if I make the range a typical $A$1:$G$22 the range name works.

 

Waz up with that?

 

Is there a work around? As is I define the range as 1000 rows, import all 1000 rows then proceed to delete the rows that have just a PK... What a waste...

 

Thanks for your thoughts.

Outcomes