Importing from Sage 50 Excel option greyed out
I have just set up my new PC, installed Sage 50 (v16, 2010), and all works fine. I tried to import my journals from an XLSX file, as I have been doing for years on the old PC, but the Excel option is greyed out, so will only allow import from csv.
new PC details:
Windows 7 Professional
Sage 50 Accounts Plus 2010 v16.0.17.0158
I have a SSD to store my programs and a traditional spinning HDD to store my data. All the sage data ie Company.000, Company.001 etc folders on are on the HDD. Sage itself is installed on the SSD. I told Sage (by editing the company (no extension) file) to find the data on the HDD, and it works fine. The one thing it can't do is import from an xlsx file.
Does anybody know why this might be happening, and what I can do to make it work properly?
Thanks in advance.