Posted by jpluimers on 2019/11/22
This indeed was an Excel 2011 for Mac thing.
Even without macros or VBA modules, Excel 2011 for Mac shows this dialog when opening a .xls file.
The solution was simple: save as .xlsx.
–jeroen
via [WayBack] Removing “Workbook Contains Macros” Prompt – Free Excel\VBA Help Forum
Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2019/11/19
I never thought you could do it, but you can: [Archive.is] Return empty cell from formula in Excel – Stack Overflow.
You have to crate:
Convoluted, but clever!
–jeroen
Posted in Development, Excel, Office, Office VBA, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2019/11/18
Not sure how long these will stay valid, but apparently my nl_office_professional_plus_2010_with_sp1_x86_x64_dvd_731121.iso was damaged (I forgot to check the hash) but I could download a fresh one from [WayBack] Download Earlier Versions of Office.
If you cannot find it by product key (I also tried it with a Visio one: worked fine too), then you can use [WayBack] Office 2010 direct link, X16-32250.exe, X16-32213.exe which are archived here:
–jeroen
via: [WayBack] Lost Office 2010 or 2013 CD/DVD? Legally Download Office From Microsoft
Posted in Office, Office 2010, Power User | Leave a Comment »
Posted by jpluimers on 2019/11/11
Lots of fuzz, but the formula towards the end worked:
=SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW($1:$25),1))*
ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)
Source: [Archive.is] How to Extract a Number or Text from Excel with this Function
More of those at [WayBack] Extract Only Numbers From Text String
–jeroen
Posted in Excel, Office, Office 2011 for Mac, Power User | Leave a Comment »
Posted by jpluimers on 2019/11/08
Why does it take forever for Microsoft Office suite programs to function the same across their various components and over operating systems. It has been like 2 decades and still sizing columns/rows in tables is a nightmare.
[WayBack] Resize a table in Word or PowerPoint for Mac – Office Support.
In my case PowerPoint: it is so different from Excel, and even different from Word, that it gives me headaches.
This is what PowerPoint 2011 could do; more recent versions are only marginally better:
PowerPoint
You can resize a whole table to improve readability or to improve the visual effect of your document. You can also resize one or more rows, columns, or individual cells in a table.
Do any of the following:
Resize a table
- Click the table.
- Rest the pointer on any corner of the table until
appears, and then drag the table boundary until the table is the size that you want.
Change the row height in a table
- Rest the pointer on the row boundary that you want to move until
appears, and then drag the boundary until the row is the height that you want.
If you have text in a table cell, the row must be the same height or taller than the text.
Change the column width in a table
- Rest the pointer on the column boundary that you want to move until
appears, and then drag the boundary until the column is as wide as you want.
If you have text in a table cell, the column must be as wide as or wider than the text.
Change the row or column to fit the text
- Rest the pointer on the column boundary until
Make multiple rows or columns the same size
- Select the columns or rows that you want to make the same size, and then click the Table Layout tab.
- Under Cells, click Distribute Rows or Distribute Columns.
–jeroen
Posted in Office, Office 2011 for Mac, Power Point, Power User, Word | Leave a Comment »
