Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2007
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I connected a spreadsheet to an Access query. I added 2 new fields to the Access query. I took all the fields back and then readded them so that the new fields were in the right order. Now, when I refresh the data, the new fields get added to the end of the spreadsheet. Now, I want to break the link and start again. How do I remove the link and relink it again to include the new fields?

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Open the Sheet

    Right Mouse click over the Data

    Choose Data range Properties

    Then remove tick from Preserve Column, Sort Filter Properties.

    Then Right Mouse Click and Refresh
    Andrew

  3. #3
    New Lounger
    Join Date
    Jul 2007
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. I will try this tomorrow when I get to work. Let you know if it worked.

Posting Permissions

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