Needs Pictures: 0
Picture(s) thanks: 0
Results 16 to 18 of 18
-
14th March 2020, 06:57 PM #16SENIOR MEMBER
- Join Date
- Apr 2007
- Location
- Sydney
- Posts
- 749
Hi Brett,
That looks like the new XLXM is corrupt. It is showing two DOCUMENTS (i.e. workbooks "Sheet24" and "ThisWorkbook") in the same project. That should not happen (or if it can I am not aware of it - but I'm no VBA expert)
I would do this:
- Open a new Excel workbook
- Go to Developer tab > Macro security > Disable all macros without notification
- Close Excel
- Double-click corrupted file, for example, Tool Control.xlsm
- File > Save as... > Tool Control.xlsb (not .xlsm), choosing the .xlsb format is what does the trick
- Go to Developer tab > Macro security > Enable all macros (or whatever level of security you normally use)
- Quit Excel
- Double-click Tool Control.xlsb
- Save Tool Control.xlsb file as .xlsm
Basically this saves the file as as a binary (as opposed to the open XML format) and can force Excel to clean up certain things. It sometimes works to save what seems a corrupted file.
If that does not get rid of the errant workbook, the longer method is:
- create a new workbook.
- copy all the data from all the legitimate sheets in original into identically named sheets in new workbook.
- copy all the code from the original to the new workbook.
-
14th March 2020 06:57 PM # ADSGoogle Adsense Advertisement
- Join Date
- Always
- Location
- Advertising world
- Posts
- Many
-
14th March 2020, 07:24 PM #17SENIOR MEMBER
- Join Date
- Apr 2007
- Location
- Sydney
- Posts
- 749
Hi Derek,
It can be RAM - just because your machine has plenty does not mean specific apps can use it all. If the app is 32bit it won't be able to use more than 4Gb
However I think I read that Apple have dropped formal 32bit support from Mohave, and that MIGHT be your problem.
Did Office give you the option of installing 32bit vs 64bit? (Sorry, I have not used Mac for a long time so have not seen a recent MS installation on Mac) If so, you should ensure you are using the 64bit version. (You can open the media that the install files are on & check the top levels of folders - you may see a file called Setup32 and another called Setup64 - if so run teh Setup64 or equivalent)
When I last used a Mac, I wrote a little AppleScript that opened certain programs in full screen by default - that might be an option.
Also had a quick squiz on Google & this might work for you
How to Make Apps Open in Full Screen Mode on Mac Automatically
-
14th March 2020, 09:10 PM #18
Hi Ross
I am still running Mojave, second latest OS, which is 64 bit but supports 32 bit. The latest OS, Catalina, will only support 64 bit, which is why I (and many others) have yet to upgrade as some of the apps we need will not run under it. Office is 64 bit and I very much doubt that there is an issue here.
RAM seems to me to be the offending area, with Excel looking like it gets hungrier and hungrier the longer it is open, even if the files open are not demanding of much. I would say that there is an incompatibility between Excel and Mojave. This did not happen with High Sierra, which can before.
With 2016, Excel would spin its wheel, which indicated that it had ran out of ram. A complete re-boot is needed. With 2019, it send out a message saying that the file is corrupt and cannot be opened. After closing and re-opening Excel, all works fine.
Regards from Perth
DerekVisit www.inthewoodshop.com for tutorials on constructing handtools, handtool reviews, and my trials and tribulations with furniture builds.
Similar Threads
-
Help with macros and Java
By Grumpy John in forum COMPUTERSReplies: 55Last Post: 28th December 2016, 10:26 PM -
Micro-Macros
By Ed Reiss in forum PHOTOGRAPHYReplies: 0Last Post: 3rd February 2013, 01:49 PM -
bandsaw is suddenly bogging down - help!
By yeoman in forum BANDSAWSReplies: 14Last Post: 21st June 2012, 11:18 AM -
New Macros
By Ed Reiss in forum PHOTOGRAPHYReplies: 4Last Post: 10th November 2011, 08:08 AM -
Help-suddenly I'm subscribed???
By AlexS in forum FORUMS INFO, HELP, DISCUSSION & FEEDBACKReplies: 23Last Post: 22nd July 2008, 11:33 AM