Using MS Project 2000 or 2002, open with MS Access. Tables in Access are linked to tables in Project. But when data is appended in project, these changes are not reflected in the linked table view in Access.
Any ideas why, or suggestions to work around?
yeah!! thanks for pointing that out to me - and you are right, updating the sheet name is reflected in the cell referencing it.
used formula below (sheet name 'OPTION B')
=MID(CELL("filename",'OPTION B'!B2),FIND("]",CELL("filename",'OPTION B'!B2))+1,30)
thank...
Thanks, Joerd - that works and it makes sense, but seems to defeat the purpose of it all, because if the sheet name changes then it is not automatically updated in the cell referencing it? I guess I am trying to do something like that, but this works for now. Maybe I have to do a macro...
Thanks - and yes I have tried both, but xls thinks "B" or "B2" is another filename and opens an explorer window... still searching for this one.
Thanks, I tried it and it looks like excel thinks "B" is another workbook, because instead of entering a value in the cell, a directory window opens with the message: "update values: B", and it wants an existing filename.
If the header/footer values were set to display path...
The post about how to put a sheet name in a cell works great for the current sheet, but I can't figure out how to reference another sheet name (on sheet "A" I want cell B2 to reference the name of sheet "B")
Which part of this formula references the sheet? (if any)...