Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calling another workbook not working
I don't get it, I just tested this out with a dummie workbook and it worked fine. Now, I'm trying to use it on the workbook I'm working on, and it's not working at all. The Name of the workbook I'm trying to call another workbook from is called "Freezer Project" and in the "Bio-Analytical" worksheet I'm trying to call the workbook "Bio-Analytical" to call the worksheet "Bio-Analytical" cell A4 while I'm in cell A4 in the "Freezer Project" workbook......When I try to call this using this formula: =[Bio-Analytical.xls]Bio-Analytical!A4 it won't work!?!?!? Is this because the names are the same???? Any info will be greatly appreciated. Thanks Joe -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=382036 |
#2
|
|||
|
|||
When a sheet/book name contains certain characters (such as that hyphen), the book/sheet name needs to be enclosed in single quotes. ='[bio-analytical.xls]bio-analytical'!a4 -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=382036 |
#3
|
|||
|
|||
Thanks MrShorty, I read about that before, and I kept trying to mess with the single quotation marks but I couldn't get it to work.....I think I've been staring at a computer screen for way too long. But thanks it works great now. -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=382036 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro working in "This Workbook", but not while in "Personal.xls" | Excel Worksheet Functions | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Formulas not working after transfering to new workbook | Excel Worksheet Functions |