Thank you to everyone with suggestions. i dont know why, but when i logged out of user profile and into administrator account the file worked correctly there, so i created a new standard user account and the file now works fine in the new profile. although machine is only a week old it somehow, somewhere after all the programs were installed something must have glitched. very strange but it works. :):)
Regards, Steve Hachey Systems Coordinator / IT Support 4607 27 St Vernon BC V1T 4Y8 supp...@johnstonautogroup.com<mailto:supp...@johnstonautogroup.com> Cell Direct: 250-309-2155 If you do not wish to receive future mailings please click here<mailto:opt...@johnstonautogroup.com?subject=Email%20Opt%20out%20Request%20from%20Commercial%20Electronic%20Mail%20iID9025> to send an opt out request ------ Original Message ------ From: "Steve Hachey - Systems Coordinator" <supp...@johnstonautogroup.com<mailto:supp...@johnstonautogroup.com>> To: "users@global.libreoffice.org<mailto:users@global.libreoffice.org>" <users@global.libreoffice.org<mailto:users@global.libreoffice.org>> Sent: 4/22/2020 1:21:50 PM Subject: Calc Question Hello, For the last few months I have been migrating our BMW store to new PC's and Email. I have taken the plunge and dropped microsoft office for libre office. almost every spreadshet we had works just fine but I've run into an issue on file that i'm hoping for advise. I have attached an Excel spreadsheet that is updated and emailed monthly to our parts team. It is used to enter a vendor number and will list a bmw part# cross reference Calc seems to struggle to open and sometimes freezes. if it does open it works fine. i'm wondering if there is a settings flag that needs tweaking in calc to make it perform correctly. here are some sample numbers to enter to test 2422600, 15571190000, 67319 & 2546200 any advice is appreciated. Version: 6.4.1.2 (x64) Build ID: 4d224e95b98b138af42a64d84056446d09082932 CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded Regards, Steve Hachey Systems Coordinator / IT Support 4607 27 St. Vernon BC V1T 4Y8 supp...@johnstonautogroup.com<mailto:supp...@johnstonautogroup.com> [cid:em415c2e85-732e-434f-99d1-852076acf95e@supportdesk] Confidentiality Notice: This electronic mail and any materials included in this transmission are the private confidential property of the sender and the materials are privileged communications. If you have received this transmission in error please notify the sender immediately by return e-mail and destroy all copies of the original message. Please click here <mailto:opt...@johnstonautogroup.com?subject=Email%20Opt%20out%20Request%20from%20Commercial%20Electronic%20Mail-smh> to send an opt out request to CEM. . -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy