Community
Showing results for 
Search instead for 
Do you mean 
Reply

Import excel xlsx problems - Act choosing wrong sheet

Highlighted
Copper Contributor
Posts: 151
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
Highlighted
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
Highlighted
Copper Contributor
Posts: 151
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