Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Oct 2013
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error when creating pivot table

    Hi,

    I appear to be getting an error when trying to create a pivot table.

    The file l am trying to access is on another area on a server.

    See attached.

    Any help would be appreciated.
    Attached Images Attached Images

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Is the source workbook open?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Oct 2013
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yes it is

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    It's impossible to tell from that picture what the range reference in the dialog is, but I would not expect to see the path there if you have the file open.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Oct 2013
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    spreadsheet

    Hi,

    I have uploaded spreadsheet for asistance with problem
    Attached Files Attached Files
    Last edited by nitsuj1972; 2013-10-17 at 10:53.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I don't ahve a problem creating a pivot table using the file and the pivot table wizard...

    Steve

  7. #7
    New Lounger
    Join Date
    Oct 2013
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I am trying to create a pivot table by accesing this spreadsheet (data) from another separate spreadsheet i.e.a pivot table containing the spreadsheet.
    Any suggestions what l could be doing wrong?

Posting Permissions

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