locked
import from excel file RRS feed

  • Question

  • Hi

    I'm trying to import an excel file that has only one table, and sometimes get these 3 tables:

    (It also happens when I use filter on the original table)

    which on of them should I import?

    how can I prevent this from appearing and just show the original table?

    Thanks

    Friday, February 21, 2014 3:46 AM

Answers

  • Hi MaYaLi,

    The data will be in the Source Table 'Store$'. It appears that Excel always exposes the print area and print titles in the list if these properties have been set for the worksheet.

     


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)



    • Edited by Michael Amadi Friday, February 21, 2014 11:00 AM
    • Marked as answer by MaYaLi Friday, February 21, 2014 1:19 PM
    Friday, February 21, 2014 10:28 AM

All replies

  • Hi MaYaLi,

    The data will be in the Source Table 'Store$'. It appears that Excel always exposes the print area and print titles in the list if these properties have been set for the worksheet.

     


    Regards,

    Michael

    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)



    • Edited by Michael Amadi Friday, February 21, 2014 11:00 AM
    • Marked as answer by MaYaLi Friday, February 21, 2014 1:19 PM
    Friday, February 21, 2014 10:28 AM
  • Thanks (:
    Friday, February 21, 2014 1:17 PM