I am using an Excel 2007 extract (file size 58MB) with Tableau 7.0 . I tried to add data from a second Excel file to this extract (Data-->file name-->Extract-->Add Data from File). The second file has the exact same headers as the first file/extract. When the process was finished, I got the following dialog box, “0 rows successfully added”. None of the data from the Excel file was added to the extract. Any suggestions on how I could fix this or what could be going on?
It sounds like you're doing everything correctly. Are you sure there's new data to be added from the new file? Perhaps you can post the two files if they're not confidential?