Cable Posted July 10, 2019 Posted July 10, 2019 Is anybody else seeing an issue with exporting to .xlsx in FMP 18? I have a scripted find/export that has never been a problem before. But, ever since I updated to FMP 18 I sometimes get errors with the Excel spreadsheet that is created. As you can see in the attached, if I make my changes and hit save it says I have to Save a Copy (if I use the same name it saves over the top of the open file just fine) because the original spreadsheet was an "older version of Excel". If I open it and try to save immediately, I get an error saying a "new version [is] available". I am using FileMaker Pro 18 on a Windows 10 machine and have Office 365 Premium.
OlgerDiekstra Posted October 25, 2019 Posted October 25, 2019 That looks more like an issue with Excel than FM. You're exporting from FM and opening in Excel. FM seems to be exporting in an older format than your version of Excel uses. Have you tried using an older version of Excel? What if you use LibreOffice Calc? I don't use Excel unless I really have to (give me LibreOffice any day), but you should be able to tell Excel to use an older format. With FM you tell it when to upgrade. With Windows 10 and Office, MS upgrades you whether you like it or not. It's well possible a chance was made in recent times after an upgrade. MS is not known for delivering quality software. Especially with Windows 10. I don't think they've had a Win10 release without issues yet. It's possible to stop Win10 from auto upgrading, none of the Win10 machines in my network upgrade automatically, some are 2 years behind now :-D, and its saved me a lot of headaches.
Cable Posted October 28, 2019 Author Posted October 28, 2019 Thanks but none of that is even remotely helpful.
Recommended Posts
This topic is 2198 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now