Hi Neil and Daniel, Many thanks for your suggestion of keeping 2011 which, fortunately, I have not removed from any of my two computers.
I read on an Excel forum that it is Apple who did put conditions on Microsoft threatening the publisher that if the conditions are not met in full, e.g. requesting ‘sandboxing’ etc, Office will not be sold in the App Store. This apparently explains why such vital functions as ‘Forms’ and some others were removed in the latest version of Excel. I doubt this explanation would be correct although I do not quite understand what ’sandbox’ is, but who knows? I am currently working on some VBA solutions, and if I am successful will share on our forum. Have a great afternoon, Philippe C. On 28 Mar 2019, at 12:31 pm, Neil Houghton <n...@possumology.com> wrote: Hi Philippe, hi Daniel, Not directly related to the original post, but I reckon keeping Office 2011 around on your computer is a good strategy. In my case, when I jumped from Office 2004 to Office 365 I found that MS Outlook in Office 365 wouldn't import the Entourage database - but Outlook in 2011 would. I didn't actually have Office 2011 at the time but I found that I could download it (I think because I had Office 365 membership - but I remember it took some finding!) and just used it as a stepping stone for the Entourage migration. I have also found that some Office 2004 documents suffered from formatting changes when opening and saving in Office 365. Often in those cases Office 2011 would hold the formatting better and then, after saving as an Office 2011 document, Office 365 would be fine. I know that, in theory, Office 2011 and the Office 2016 (in Office 365) use the SAME format - but maybe Office 2011 handles the old format better. In fact, dealing with MS products often reminds me of the quote (attributed to many, including Einstein & Yogi Berra but preceding them both): "In theory, there is no difference between theory and practice; but in practice, there is." Cheers Neil -- Neil R. Houghton Albany, Western Australia Tel: +61 8 9841 6063 Email: n...@possumology.com -----Original Message----- From: <wamug.org.au-wamug-boun...@lists.wamug.org.au> on behalf of Daniel Kerr <wa...@macwizardry.com.au> Reply-To: WAMUG <wamug@wamug.org.au> Date: Wednesday, 27 March 2019 at 01:28 To: WAMUG <wamug@wamug.org.au> Subject: Re: Excel - Office 365 Data Entry Form Hi Philippe As I don’t really use those features, I’m not 100% sure,…but a quick look around found these,…if they help? https://support.office.com/en-ie/article/create-forms-that-users-complete-or-print-in-excel-fd6797c2-30b6-42d8-9921-0feb123f5ca7 https://techcommunity.microsoft.com/t5/Excel/2019-Excel-on-Mac-no-data-entry-form/td-p/286728 The other option for those that require forms, is that you can still use Office 2011 as well as the later Office365. (If you kept it on your computer). If Office 2011 is still on your computer in the Applications folder then you can open Microsoft Excel and open the file you want from the “File - Open” menu. (or you can right click on the file you want to work with and choose “Open With”. then choose “Microsoft Excel 14.7.7 or 14.x.x (Version 14.x.x is Office 2011 and version 16.x.x is Office365 currently). That hopefully will then give you the best of both worlds to access old data files that have,…and use the new version for other things. But yes, in Office365 they did remove quite a few features that Mac users were used to unfortunately. (Even some keyboard commands that were around since Excel 1.0,…they decided to change the keyboard commands “to be the same as Windows”. Or if we had features that weren’t in the Windows version they removed them rather then “trying to put it into the Windows version”. So either way,…we Mac users always seem to get the short end of the stick! Hope something there helps. Others who use it a lot more in-depth then me have some other answers. Kind regards Daniel --- Daniel Kerr MacWizardry Phone: 0414 795 960 Email: <daniel AT macwizardry.com.au> Web: <http://www.macwizardry.com.au> **For everything Apple** NOTE: Any information provided in this email may be my personal opinion and as such should be taken accordingly, and may not be the views of MacWizardry. Any information provided does not offer or warrant any form of warranty or accept liability. It would be appreciated that if any information in this email is to be disseminated, distributed or copied, that permission by the author be requested. > On 27 Mar 2019, at 1:16 am, Philippe Chaperon <laut...@bigpond.com> wrote: > > > Good morning dear WAMUG’ers, > > Can someone who uses Excel from the Office 365 (for Mac) suite confirm that > the the Data Entry Form facility has been removed by MicroSoft? > > I have always used this facility for data entry of some large spreadsheets I > use. And only 1 week ago took the plunge and took a subscription for Office > 365 and was surprised to find that the Data Entry Form button, from my Excel > 2011 spreadsheet, just does not work. I have gone through many Excel forums > and to my horror have found that M/S has somehow made the Mac version of > Excel but a very poor cousin of the Windows version. > > Has anyone got a solution, possibly via VBA? If not I feel I have made a big > error to update MS Office to 365. > > Any help or suggestion will be appreciated. > > Many thanks & best regards, > > Philippe Chaperon > > -- The WA Macintosh User Group Mailing List -- > Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> > Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> > Settings & Unsubscribe - > <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug> -- The WA Macintosh User Group Mailing List -- Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> Settings & Unsubscribe - <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug> -- The WA Macintosh User Group Mailing List -- Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> Settings & Unsubscribe - <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug> -- The WA Macintosh User Group Mailing List -- Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> Settings & Unsubscribe - <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug>