Microsoft Office

59K

Solutions

40K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Share tech news, updates, or what's on your mind.

Sign up to Post

Looking at professional certifications? I've discovered that community colleges near me offer Adobe, Microsoft and CompTIA certification exams free of charge! You might find an academic testing center near you that does the same or offers a great discount. Considering these exams usually cost $150-200 when administered by private testing centers? Woot!

http://www.certiport.com/Portal/desktopdefault.aspx?tabid=673&roleid=101

https://home.pearsonvue.com/test-taker.aspx

For more information about the exams available and how to prepare for them:

https://www.microsoft.com/en-us/learning/default.aspx

http://www.adobe.com/education/certification-programs.html
0
Office 365 Training for Admins - 7 Day Trial
LVL 2
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

0
Xenapp 6.5 Intermittent issues since KB4012215 (WannaCry security fix)

Hi All,

Ever since we installed KB4012215 as part of MS recommended protection against ransomware\ 'Wannacry' into our Windows 2008 R2 Xenapp 6.5 base image we've seen constant intermittent issues with file handles and permissions related to user profiles, UPM, Office applications and RDS.

Issue 1 - when user logs on\ launches a session:  
Word - 'your autocorrect file C:\users\user\appdata\roaming\microsoft\office\MSO3081.acl could not be saved - click OK 'Word cannot open the existing file normal.dot'

Issue 2- when user logs on\ launches a session:
Outlook signature file goes missing for customers - they'll add and then they'll lose it again on another session later.

There seem be weird file and handler locks and registry handles not being released properly or quickly enough after logon. i.e. an application wont recognise required datafiles (XML) in user\ \appdata\roaming profile folder even though the file\ folder definitely exists and can be written to.
To our frustration we cannot replicate the problem however it seems that the issues manifest when a user logs onto a specific CITRIX server the first time around and then relaunch an application session on THAT server again within a given timeframe. Testing further indicates that if a user is logged off completely and then they log back onto that same server the issue is NOT present.
A server …
0
 

Author Comment

by:loubot loubot
thank you Andrew- I have now done so

Appreciate your time to assist :)
0
 
LVL 11

Expert Comment

by:Andrew Leniart
My pleasure. Good luck with your question :)
0
"Get powerful new insights to make better business decisions
Workplace Analytics leverages Office 365 collaboration data to deliver powerful new insights for enterprise productivity. It helps business leaders understand collaboration patterns across organizations that influence productivity and employee engagement."
1
 
LVL 4

Author Comment

by:☁ François Peroux ☁
It wasn't my goal to plagiarize any content just to share with people here. As you can see I put " ... " meaning it's a citation.
0
 
LVL 66

Expert Comment

by:Jim Horn
Try not to take this the wrong way, but experts here see advertisements like this all the time, so we really don't need other experts copy-pasting them as their own post.  If you have a vested interest in this product then we'd prefer that you at minimum provide some unique content as to why we should view this.  Better yet would be to contact EE and pay for a vendor account.
0
Now cancel the meeting for an office 365 mailbox using PowerShell CMD Remove-CalendarEvents

Please check out my post on the same here.

https://www.experts-exchange.com/articles/30640/Remove-CalendarEvents-Cancel-future-meetings-in-user-or-resource-mailboxes-in-Office-365.html

0
i have never seen an worse program the Microsoft outlook. Initially I thought it's only me, but since I am following question on the exchange and see how many IT pro have issues with outlook I know outlook is nightmare for anyone who use it in a office environment.  until google will not come out with a email client I don't believe there will be any big improvement. Microsoft does not get scared from any competition other then google and need to say in every product google competed with Microsoft we have seen major improvements or rather say recreation. Is it on google agenda? why not? thy have a office product so why not email client?
1
 
LVL 96

Expert Comment

by:Lee W, MVP
Now you know what google says:
Google search
2
 
LVL 13

Expert Comment

by:Dustin Saunders
Honestly, Abaraham, I'm not disputing you that Outlook is a big search topic.  But like has been said, it's the industry dominator, so since EVERYONE uses it doesn't make sense that there are a lot of questions?

Data-wise, how many of those questions are how-to or user correction?  Or ended up being 'Did you disable this add-in and it started working again?'

I get your point, and I think it's fair really, but since it's such a widely used program it makes sense there are occasional bugs and that they get posted.  But whether a program is good or not can be widely opinion based, people are entitled not to like it for any reason they choose.  I think the nice thing about a site like EE is that we can help people work with their issues and enable them to use the tool that is industry standard.
2
Like most people, I hate spam! - Which is why I love Mailwasher Pro!  I highly recommend it and no, that's not my affiliate link. Though I do have one :)

I've yet to try another anti-spam solution that gives me as much control over my mail and that works as well as this software does in keeping spam out of my Inbox, while never affecting the mail I want to keep.

Here's an example screen grab I just took to show why I'm so fond of it.

Mailwasher Pro Partial Screen Grab
Every action in this screen shot was pre-marked automatically for me without my needing to do a thing. I have the option to over-ride anything with a quick mouse click and the program will remember my preferences for the next time it checks.  I can also safely preview any email in that list using plain Text or HTML format and even shoot off a quick Reply or Forward if I want to, without needing to bring it into Outlook.

When I want to bring in my email, I just hit the big "Wash Mail" button and it deletes all the garbage from my mail server's host, opens (or maximizes) Outlook and I click send/receive in there to bring in only the good stuff that I want to keep.  Spam hasn't made its way into my Outlook for years now.  I also have it installed on both my IPhone and IPad.

When I do want to adjust my additional "self created" filters, the provided filter creation tool is great so the process only takes seconds to do.  If you hate spam as much as I …
1
 
LVL 18

Expert Comment

by:Lucas Bishop
1
 
LVL 11

Author Comment

by:Andrew Leniart
Yep.. That's a risk with many web based (or even managed) solutions.  You're always at the mercy of whoever runs the service.

I'm a bit of a control freak at heart, so Mailwasher suits me down to the ground.  Having used it for so long, it's learning history rarely (if ever) gets it wrong for me these days.

Thanks for sharing your experience!
0
For you the  Machine Learning fans.Microsoft Cortana Speech Recognition Now Allows You To Dictate Text In Office Apps (video):

http://flip.it/NkmwBv
6
How to deselect cells in Office 365 Excel?
0
 

Author Comment

by:elgin229
I am sorry because this issue is really bugging me.  I'm running Excel Office 365 on Windows 10 i7 7700 and the control +click does absolutely nothing.

Please don't take it as blunt I'm just stating a fact after 2 or 3 hours of looking for the answer.

The marque just keeps rolling around the selected cells.

Thanks for offering an answer albeit not the correct one.
0
 
LVL 9

Expert Comment

by:James Bilous
You might want to reask this as a question in the excel topic area for better results, instead of via a post.
0
outlook folders unstable, Every time my client clicks on delete, it transposes, or physically moves and makes itself inbox. so he has to be carefull between the two folders,
outlook 2016 , on MS office small business.

its been on for about 3 weeks now


0
Online Training Solution
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Happy to share my first article published on Expert Exchange.
guys, please check it out and if you like it please give your endorsement to the article, so that I get more point for my level up :)

This article talks about exporting Office 365 Mailbox to PST using the new EOP portal.

https://www.experts-exchange.com/articles/30379/Exporting-Emails-to-PST-from-Office-365-Mailbox.html
3
 
LVL 7

Author Comment

by:Sunil Chauhan
that's rights, PSTs are hated by E-Discovery team, as they can not be searched through, but there are times when you need to export the data to PST from Office 365, like: migrate the mailbox to another office 365 tenant, or on a client request, some time compliance team may request to export data from users mailbox etc.
1
 
LVL 6

Expert Comment

by:Brian Matis
Makes sense. Thanks!
0
1
what is the maximum number of cells microsoft office 2013 excel application supports
0
 
LVL 9

Expert Comment

by:James Bilous
1,048,576 rows by 16,384 columns = 17,179,869,184 cells
2
 
LVL 66

Expert Comment

by:Jim Horn
Microsoft publishes pages on Excel Specifications and Limitations for every new version that answers tons of questions like this.
1
Don't expect others to have VBA/macros enabled in MS Office. Stuff like this is why. I disagree with the author's opinion that PowerPoint should be avoided, but it's no different than Adobe Illustrator - knowing how to use the app doesn't make you an artist.
3
 
LVL 25

Expert Comment

by:Echo_S
Very true.

But I will say that I rarely see macro-enabled PowerPoint files (PPTM). Most of the experts who I know (many of whom are answering the PPT VBA questions here) don't send the code in a PPT file because, well, because PPT doesn't really work like Word and auto-execution is not the easiest. For that reason, and probably many more reasons in addition, most of them distribute add-ins, which are a different animal altogether because they must be installed or at least activated intentionally, unlike macros.

Anyway, what you said -- it's all the more reason to be safe out there!
0
 
LVL 9

Author Comment

by:Colleen Kayter
Macro-enabled PPT files may be rare in the wild, but I've seen people ask about things like using VBA to open all the Excel files in a folder and "automatically" create charts in PowerPoint. For the sake of their audience, I could only hope they planned to spend a few hours formatting those charts. "Automatic" slide decks are what gives PowerPoint a bad rep. ;-)
1
For those new to Office 365 admin center, here is a blog I wrote up to help you learn 2-step verification and MFA. https://callthatgirl.biz/how-to-setup-office-365-2-step-verification-and-multi-factor-authentication/How-To-Setup-Office-365-2-Step-Verif.jpg
2
1
5
Quickbooks Scam

I had a client ask about using Quickbooks in multiple locations. My suggestion is to use the web version for eas of use and you get at least 3 user accounts vs having to buy multiple licensees for the desktop version.  

Just as I walked into the office I was told Quickbooks had already called in and was remoting in and working on it.  I asked my client which version and he was not sure.  I went to the computer and saw a big string of pings going through the command prompt.  Suspiciously, I  Jumped on the Teamviewer chat and asked if they are migrating to the web version or using the desktop. The "tech" asked if he could call me directly.  His voice was very hurried with a heavy accent and said if we went to the web version, payroll wouldn't work.  I know that is not correct and this didn't feel right and I asked if I could call him right back at the same time I ended the TV session.

Called into Intuit to verify and at the same time saw two payments from some electronic payment company that was not Intuit. One for $449.99 the other $999.99.  Both were for "Tech support" and not an actual product.  

I explained to my client he had been scammed.  In his email, I saw there was a password recovery. I asked if he gave out his password to the "tech".  Of course he did.  I had him change his password for his email account and quickbooks.  Next call was to the credit card company.  Right away there is a recording, "It looks like there are fraudulent …
3
 
LVL 6

Expert Comment

by:Brian Matis
Ugh... That sucks. Glad you were able to help them catch the problem quick. Nice work and thanks for sharing the head's up about this kind of thing.
0
 

Expert Comment

by:Daniella Barion
Thanks for sharing.  Unfortunately, these fraud events happen more than we can imagine.  We need to be always on alert.
1
New member today got a solution today.

After searching the net for help it became apparent that there were professional contributors on your site willing to provide expert advice. The advice given was very fast and first class.

Fred
This was their question that was answered.
https://www.experts-exchange.com/questions/29012797/Create-Dynamic-Range-Via-VBA.html
3
Lesson learned this weekend: when doing a cut-over migration to Office 365 Exchange online, make sure you don't have existing users in Office 365,   Migration will refuse to provision the users as duplicates (seems like a bug to me).
1
 
LVL 58

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
hum, still getting all comments.

We'll make this a long one

by spacing out some lines

and so forth.

and talking a lot about nothing.

just some hot air

can't wait for the balloon fest
1
 
LVL 6

Expert Comment

by:Brian Matis
Ha! Nice experimenting :-)
0

Microsoft Office

59K

Solutions

40K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.