Results 1 to 2 of 2

Thread: How to control formatting external data in 2007?

  1. #1

    How to control formatting external data in 2007?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm pulling in data from SQL via a query connection in Excel 2007, but when the data is pulled in it disrupts the headers [adds blank columns] when I am pulling the data in underneeth [row13].
    In Excel 2003 the External data connection could be controlled to not change column formatting but I can't find this in 2007?

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,343
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    I don't have 2007, (only go back as far as 2010,) but are you pulling this into an Excel table?

    If it is, and you select any cell in the table, you should see a Table Tools tab pop up. On the third group there is a Properties button. In there should be a few options to control how the table loads.

    Hope this helps,
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Tags for this Thread

Posting Permissions

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