+ Reply to Thread
Results 1 to 2 of 2

invalid bracketing of name 'xls.'.

Hybrid View

  1. 06-11-2008, 05:59 AM #1
    mmf
    mmf is offline
    Forum Contributor
    Join Date
    06-15-2007
    Location
    Scotland
    Posts
    142

    invalid bracketing of name 'xls.'.

    I am getting this error when I try to query an excel sheet using import external data.
    I am do know hoe to get rid of it.
    Any body could help me or suggest why this could happen?
    Reply With QuoteRegister To Reply
  2. 06-11-2008, 06:10 AM #2
    Simon Lloyd
    Simon Lloyd is offline
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Without more information we can't really help but the convention for bracketing external references is like this for an open workbook:
    =SUM([Book1.xls]Sheet1!A1:A20)
    if you want to specify a source that is not open its like this:
    =SUM('C:\MyFolder\[Book1.xls]Annual'!A1:A20)
    Not all forums are the same - seek and you shall find
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1