| View previous topic :: View next topic |
| Author |
Message |
larmenta Newbie

Joined: 10 Nov 2005 Posts: 1
|
Posted: Thu Nov 10, 2005 9:57 am Post subject: OPENING EXCEL WITH TABLE LOOKUPS TO EXTERNAL SHEET FAILS |
|
|
I AM TRYING TO USE OFFICE CALC 2.0 FOR THE FIRST TIME.
I OPEN ONE SHEET THAT HAS MANY FORMULAS TAKING VALUES FORM OTHER SHEET.
IN EVERY CELL THERE IS A FORMULA LIKE THIS ONE:
=E$61-$B62*BUSCARV($C62;'C:\ict\ictmodelos\AT.xls'!ATPASO;COLUMNA()-3;FALSO)-BUSCARV($D62;'C:\ict\ictmodelos\AT.xls'!ATPASO;COLUMNA()-3;FALSO)
AND I GET IN CALC:
=E$61-$B62*BUSCARV($C62;#NOMBRE!ATPASO;COLUMNA()-3;FALSO())-BUSCARV($D62;#NOMBRE!ATPASO;COLUMNA()-3;FALSO())
AND A ERR:508
IT LOOKS LIKE CALC DOES NOT UNDERSTAND 'C:\ict\ictmodelos\AT.xls'
ANY HINT ON HOW TO MAKE CALC UNDERSTAND ABSOLUTE PATH TO THE FILE THAT CONTAINS ALL OF MY BASE TABLES?
I HAVE TRIED THE ENGLISH VERSION AND AFTERWRADS THE SAPNISH VERSION OF CALC WITH THE SAME RESULTS (#NAME INSTEAD OF #NOMBRE)
THNAKS  |
|
| Back to top |
|
 |
uros Super User


Joined: 22 May 2003 Posts: 601 Location: Slovenia
|
Posted: Fri Nov 11, 2005 12:19 am Post subject: |
|
|
Hi larmenta!
OOo requires URL notation for linked cells, something like this:
| Code: | | 'file:///C:/ict/ictmodelos/AT.xls'#Sheet1.A271 |
I'm not sure but afraid that you couldn't use range names ("ATPASO").
Uros |
|
| Back to top |
|
 |
|