Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT should be updated to work on closed workbooks.
Dear Microsoft:
We've been forced to use user-built functions to try to access information in closed workbooks using referenced cells (INDIRECT.EXT). We do this because INDIRECT doesn't work on closed workbooks. Considering most people who use INDIRECT are going to be using it on some kind of network, Microsoft should think about updating this function to read from closed spreadsheets. Who wants to take up the bandwidth and local RAM by opening every sheet needed to update one workbook? INDIRECT.EXT has limitations when used within other complex functions, so it's not really a 'workable' solution. "It appears as though INDIRECT.EXT doesn't work in conjunction when used within specific functions. For example, Peo says it works fine on his system, yet it doesn't work on ours (even though we have confirmed there are no policy restrictions that would cause this to fail). Yet, when I use INDIRECT.EXT this way: Cell F148: =IF(ISNUMBER(INDIRECT.EXT(S148)),INDIRECT.EXT(S148 ),"") Cell S148: ''G:\GS_Secure\REPORTS\Monthly\HiPath\USER_SUMMARY \10\[USER.xls]Sheet1'!$B$3 (two apostrphe's at the beginning) it works fine. It appears to become unstable when using it in something complex like VLookup, but it can be evaluated using a simple IsNumber. Sure wish PULL worked. Either way, they are both incredibly slow when using a lot of them in spreadsheets (every time I try to update one, I have to wait a good 10 seconds for cells to update). Maybe microsoft can take this into account for their next release." ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what exactly prevents INDIRECT from accessing closed worksheets? | Excel Worksheet Functions | |||
How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions |