+ Reply to Thread
Results 1 to 3 of 3

External Data Range into a Table

  1. #1
    Registered User
    Join Date
    01-30-2017
    Location
    New England
    MS-Off Ver
    Professional Plus 2010
    Posts
    1

    Angry External Data Range into a Table

    So I have a set of data I am importing from a *.txt file which imports into a 4col ~4000row sheet. I want to be able to sort this data alphabetically/numerically in any column. If I simply go to create table I am prompted with a message that says creating a table breaks external data sources. Is there any way to fix this? My temporary solution is to import the data into "sheet 2" then copy onto "sheet 1" and make that a table. Any better solutions?
    I don't use excel often so sorry if this is a simple question.

    Cheers

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: External Data Range into a Table

    Welcome to the forum

    How are you importing the data - vba? manually?
    Is there an error number? What is the EXACT wording? Not seen it before.
    Please attach say the first 20 lines of the text file (as a .txt file) to allow your error to be re-created
    (test that the error still occurs with reduced file before attaching it)
    Also post your VBA - using code tags - click on # icon above)
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: External Data Range into a Table

    Hi,

    Have you tried using Power Query?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pivot table doesn't update from external csv while data table does
    By Nick_Berlin in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 11-30-2014, 06:50 PM
  2. External web data query fails to insert table data
    By watkincm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2014, 04:06 PM
  3. Replies: 0
    Last Post: 10-23-2013, 09:01 AM
  4. Create a table from external data
    By flyingbriantb10 in forum Excel General
    Replies: 1
    Last Post: 06-16-2011, 04:30 AM
  5. External Data Range
    By blatham in forum Excel General
    Replies: 0
    Last Post: 11-22-2006, 07:37 AM
  6. [SOLVED] [SOLVED] External table/range reference trouble
    By DoctorG in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2005, 08:05 AM
  7. [SOLVED] Pivot table using External data
    By nc in forum Excel General
    Replies: 3
    Last Post: 04-26-2005, 08:06 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1