Community
Showing results for 
Search instead for 
Do you mean 
Reply

Import excel xlsx problems - Act choosing wrong sheet

Copper Contributor
Posts: 108
Country: Canada

Import excel xlsx problems - Act choosing wrong sheet

Trying to Import data from Excel 2007
file has three spreadsheets


Keeps choosing the same spreadsheet, and does not let me choose the one that I need.


I have tried moving spreadsheets around, naming data areas - but it keeps choosing data from the same page.

Any ideas on how to make this work?

 

Yes I know I could go and make a CSV or TXT file, but the program is supposed to import Excel files.

 

Thanking you in advance for any assistance you may provide.

Tom David Moxam
Platinum Super Contributor
Posts: 5,275
Country: USA

Re: Import excel xlsx problems - Act choosing wrong sheet

ACT! isn't designed to import from multiple spreadsheets within an Excel file. You'll want to save the file to a new name, remove the sheets you do not want imported, save and close the file, then import the edited file.
Greg Martin
Sage
Copper Contributor
Posts: 108
Country: Canada

Re: Import excel xlsx problems - Act choosing wrong sheet

thanks for the reply

 

that is what i ended up doing

 

what i question is no matter what order i put the sheets in it always chose the same one????

Tom David Moxam