Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using the function OFFSET in a file to look for the values in another
file. But when I close the two files and later I open only the file where this the function OFFSET, appears me the mistake #VALUE. Para that the values come correctly, I have to open the two together files. Does anybody know how I can solve this problem of link? Because the file should be opened daily, but without opening the origin of the data. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OFFSET problem | Excel Worksheet Functions | |||
Offset Problem | Excel Discussion (Misc queries) | |||
OFFSET PROBLEM | Excel Discussion (Misc queries) | |||
Offset VBA Problem | Excel Discussion (Misc queries) | |||
Offset function problem-Dynamic range | Excel Discussion (Misc queries) |