Why don't you try using the Paste function feature and make sure you are getting
to the proper function? When I put the function in my Personal Macro Library -
the Paste Function puts in =Personal.xls!SheetName() in the cell which then
returns Sheet1 in the cell.