Jun 28 2019 04:10 AM
Hi, I have created a relatively basic Excel spreadsheet which contains Macros that were created within the worksheets. All calculations and macros were working perfectly and with some pride, I saved the file. However, Excel requires that the file format is converted to .xlsm (macro enabled). So I naturally 'went with it' and selected the .xlsm extension. When returning to the file a little later, excel couldn't open the new file!! After a few fiddles with the 'properties', I managed to get the thing open and with a few more fiddles, managed to resolve the 'error messages' that had magically appeared. So all good on MY computer, but when I send the file to collaborating colleagues, they are experiencing difficulties in that the cells containing calculations are not working. I'm sure I will not be the first to have experienced this problem and hope that someone far more intelligent out there may have a solution to this.
Jun 28 2019 07:21 AM
Jul 01 2019 06:33 AM
@Jan Karel Pieterse Sorry for delay in getting back to you - No, all set up for Automatic calculation, but thanks for the thought!
Jul 01 2019 07:49 AM