Re: Excel - Office 365 Data Entry Form

[Philippe Chaperon]

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  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:  on behalf of Daniel Kerr 

Reply-To: WAMUG 
Date: Wednesday, 27 March 2019 at 01:28
To: WAMUG 
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: 
  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  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 s

Re: Excel - Office 365 Data Entry Form

[Neil Houghton]

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:  on behalf of Daniel Kerr 

Reply-To: WAMUG 
Date: Wednesday, 27 March 2019 at 01:28
To: WAMUG 
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: 
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  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/mail

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 -