Re: Excel - Office 365 Data Entry Form

[Daniel Kerr]

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: 
Web:   


**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  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 - 
> Guidelines - 
> Settings & Unsubscribe - 
> 

-- The WA Macintosh User Group Mailing List --
Archives - 
Guidelines - 
Settings & Unsubscribe - 

Excel - Office 365 Data Entry Form

[Philippe Chaperon]

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 - 
Guidelines - 
Settings & Unsubscribe -