Excel For Mac 2011 Nested If Site:Answers.Microsoft.Com

Copy sheets to the new created workbook to see the result.I'm using Excel for Mac 2011. Create a new workbook from within Excel 2016 for Mac. If so, the first we can try is: Open the workbook in Excel 2011 for Mac. Here are my observations:If this means Office 2016 for Mac, please check the information below: Please check if the issue only happens to this specific workbook. It seems this bug has existed for many years and has no definitive answer - or even useful workarounds if it is persistent.

Following that error, ifThe file is closed and reopened, it is also impossible to save it - even without any action made on the spreadsheet after being opened.The only way out of this is to restore an older version of the file from a backup copy, bring it up to date and Save it. The error 'Not Enough Memory' pops up when the Save is attempted. Then, with no different changes, it becomes impossible to save the file. The spreadsheet functions perfectly for weeks. The spreadsheet is 2.3MB in size. The Preferences General 'At start up, open all files in' box is empty.Call.

In Office 2011 14.7.7 is the current and final version. Sorry that I had to press the issue, but there are times when several different versions of Excel are current versions. I have usedThis process and repairing disk permissions and refreshing the Preferences plist files worked once. At the time the error occurs, other spreadsheets, some bigger than 2.3MB, function properly.This site has suggested a procedure to use to get around the problem:В . After this, the file works ok for a few more weeks - but then hits the same 'Not Enough Memory' error and the restore has to be done again.The error is not related to not being enough memory - either in RAM (usually over 1.5GB unused when Excel is active) or on disk.

'Independent Advisors' work for contractors hired by Microsoft. All I can suggest is to start with this list and rule them out one-by-one:I am an unpaid volunteer and do not work for Microsoft. It appears you have researched and tried deleting preferences, with past success but not current or lasting success.Unfortunately, there is a whole lot of possible causes of out of memory errors in macros. In Excel 2016 there can be up to 6 different versions, all 'the latest,' at any given moment.Anyway, the scenario you described has occasionally turned up in the forums.

Excel For Mac 2011 Nested If Site:Answers.Microsoft.Com