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:   


**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 - 

Re: AGM and Nominations and Subscriptions.

[WAMUG Annoucement]

G’day all WAMUGERS.

Two quick notifications.

First, nominations for the Officer positions on the committee were very limited 
and there being no more than one nomination for each of only a couple of them 
the nominees will be elected unopposed next week at the AGM. There were also 
only a couple of nominees for the committee members so they will also be 
elected unopposed next week. Consequently, there will be no postal vote 
arranged.

Secondly, the list membership was updated last night and anyone who was not 
financial was moderated (very, very few). If you go to post and find your 
message held “for moderation”, it means that we did not have a record of your 
payment. If you have paid, could you please resend a copy of the payment or 
details so that we can fix it up (to members...@wamug.org.au 
).

Regards,

Pete Smith

> On 19 Mar 2019, at 22:52, WAMUG Annoucement  wrote:
> 
> G’day all WAMUGERS.
> 
> The 2019 annual general meeting of the Western Australian Macintosh Users’ 
> Group will be held before the next monthly user group on Tuesday, 2 April 
> 2019, starting at 7.30pm.
> 
> Nominations are being called for positions on the committee as all positions 
> will be declared vacant. The closing date for nominations is next Tuesday, 26 
> March 2019 at 5pm. If there is more than one nomination for any of the four 
> Officer positions, a vote will held on the night to elect a nominee to the 
> relevant position. There will also be an online voting form to enable those 
> unable to attend the meeting to vote. If there is only one nominee for any 
> particular position, the person will be elected unopposed and no online vote 
> will need to be cast for that position.
> 
> The four Officer positions available are:
> 
> 1 President.
> 2 Vice President.
> 3 Treasurer.
> 4 Secretary .
> 
> Plus Committee members.
> 
> Please consider helping out by coming onto the committee.
> 
> If you have any queries in regards to the committee positions, please feel 
> free to drop me an email via the List. Please type AGM query in the Subject 
> line to enable easy identification of your email.
> 
> Subscriptions.
> 
> To be eligible to vote in the AGM you must be a current financial member. 
> Subscriptions for WAMUG are based on the calendar year so the 2019 annual 
> subscriptions fell due on the 1 January this year. A big thank you to all 
> those who have paid up and maintained their membership.
> 
> As is the usual practice, next Tuesday evening in the week before the AGM, 
> the membership list will be gone through and any unfinancial members will be 
> blocked from posting to the list until they become finacial, although you 
> will still receive your daily digest or individual messages. You just won’t 
> be able to post to the list and get help. More importantly, you won’t be able 
> to vote in the AGM.
> 
> Regards,
> 
> Pete Smith
> 
> -- The WA Macintosh User Group Mailing List --
> Archives - 
> Guidelines - 
> Settings & Unsubscribe - 
> 

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