Microsoft Office

66K

Solutions

42K

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

My OS is win 7 64 bit and I use Outlook off the office 365.  How do I modify the new email template and also for replying to a email, it should use this same template.  thank u
0
Big Business Goals? Which KPIs Will Help You
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

My OS is win 7 64 bit and I use Outlook off the office 365.
From the home page, how do I add a new folder to the side ribbon as in the graphics, eg the Inbox .  what is the max number that I can add?  thank u
outlook.JPG
0
Hi,

I used below to draw one flow diagram
https://www.draw.io/

when i saved to my computer it is saving as .XML file

I want to save it as image file for my diagram

how can i achieve this

please advise
0
Karen is a friend of mine whose Excel 365 has a neat "cell deselection" feature:


For instance, she can select [1:20]  then delselect rows 5 10  by ctrl clicking on them.  She is left with [1:4,6:9,11:20].

My version of 2016 and does not have this feature.  

I always thought that Excel 365 was built on top of Excel 2016 so I was  surprised by this difference.

One theory I have is that both versions are indeed identical, but that some registry entry enables the deselection on her computer but not on mine.

Can anybody point me to documentation about when this feature was first introduced?

rberke
P.S.
15 years ago I implemented an Excel 2003 Personal.xls program to support the feature.  Since then I have migrated through Excel 2007, 2010 and 2013. None of them supported deselection unless I added personal.xls to XLSTART.
0
Hello I've never built a cascading dropdown from scratch.  I have a template that I use every time I need to create one.

Please use the attachment as guidance

Question 1 - On the Tracking Worksheet tab, when select DMI in Area, Column E only gives the selection of Reporting and Reporting when it should be Reporting and Soup.  (selecting TCS in column C does it correctly)

Question 2 - Why when you select an Activity List on the Tracking WorkSheet tab, all the selections on Column I on the Service_Activity List tab are displayed?

Is it all in the order or is there a way to do a cascading dropdown where it works as intended?

Example, On the Tracking Worksheet  tab When you select DMI then Reporting is the only selection and then there's only 3 selections in column I Activity

I have a work around but it requires putting (DMI) at the end of Column B on the Service or Deliverable and (DMI) at the end of every activity that's selected for the Area DMI (same exercise for (TCS), (GR), (SS)

Question 3, this is a nice to have, but it might require coding, If you make all the proper selections, and then go back and change G, is there a validation that tell you Column H and I are incorrect?
Cascading-dropdowns---Expert-Exchan.xlsm
0
Hello

I have an Excel file which I have forgotten the password.

Is it posslble to recover?

Thanks.
0
We have Office 365 for Exchange. Is it possible to add a message to every users email (new, reply, forward) under the signature?

I've tried adding a Disclaimer, Message Rule but this just adds a message to the bottom of the email and not below the signature.
0
Hi

I have one domain PC which keeps flipping over to US Keyboard, none of the other PC's in the office do it. It seems to happen when the PC is left for a long while. Ive used lpksetup /u to uninstall and other language but only UK is installed. Ive also checked out the various locations in the Control panel which relate to keyboard etc and can only ever see the UK keyboard installed. However when using the Windows+Spacebar shortcut, it shows the two options, US and UK. I logged into the PC as local admins to check but didnt find anything there either (all UK and no US).

How can I stop this from happening, all other machines on the domain dont do it so its a real odd one.

Windows 10 Pro is the OS

Thanks
SycamoreIT
0
update formula

=IF(OR(T4>=0,S4>8%),"Update Quote",IF(AND(T4<1000,S4<4%),"FVP Approval","RSVP Approval"))

I'm trying to update this formula for the second part:
IF(AND(T4<1000,S4<4%),"FVP Approval","RSVP Approval"))

to catch  T4 >0 AND < 1000   ?

not working ?
IF(AND(T4>0 and t4<1000,S4<4%),"FVP Approval","RSVP Approval"))
Thanks
fordraiders
0
In open office how to insert one shape inside other

as attached i have big rectangle
I like to insert small circle into that rectangle
how can i achieve it

please advise
OpenOfficeShapes.png
0
OWASP: Avoiding Hacker Tricks
LVL 12
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

visio 2013 standard i opened blank diagram,

I do not see any shapes like circles, rectangles, person, arrows etc on the left hands side

how to enable them and keep them there all the time so that whenever i open visio i can just drag and drop and make the diagram
please advise
0
I have a user who wants to enter narrative descriptive text into a cell and to have it expand automatically as she enters text. I have already suggested using a hyperlink to a document (no go due to her setup) . I have suggested adding a comment to the cell and then use the printing options to print the output of the cell (the document has to be printed and signed) either on the screen or at the end. However, I want to know if there is a better way to do this...or am I missing something>
0
I need to setup trusted locations within some Office 2016 apps, but I'm wanting to push these out via GPO.

I've downloaded the admin templates from the Microsoft website, but I need a guide on how to set these up essentially from start to finish.

If anyone could help, that would greatly be appreciated.
0
Office 2016 freezing Outlook, Word, and Excel freezing up
0
Hello Experts,

I am trying to understand how does it works shortcuts for excel format data options
 Format-data-options.pngI see that most of the options contains an underline for a letter however I type alt + the letter and it doesn't work.
I also try alt + shift and I have the same result.
Could you please advice?
Thank you in advance for your help.
0
HI, have upgraded to Excel 2016 and since then I cannot open all my excel files located on my DLINK NAS.  I have added the DLINK NAS into the Trusted locations but still no joy.

Any ideas?
Screen-Shot-2019-01-20-at-13.51.23.png
0
Dear All


              I have recently Migrated on premise exchange mailbox to O365 but I found it can not connect to outlook on premise window 7 computer, and I found out my exchange ssl certificate only contains "mail.domain.com" but not "autodiscover.domain" , what I need is a Muti SAN certificate, but I just created below SRV record in public DNS server instead of buying a Muti SAN certificate, after that I tested but it still can not connect in outlook for the migrated mailbox, see bottom screenshot,  I receive the popup saying that it redirecting to https://mail.domain.hk/autodiscover.autodiscover.xml , what I can do in order to get this resolve ? any help would be appreciated


Service: _autodiscover
Protocol: _tcp
Port Number: 443
Host: mail.domain.com


1

1
1
I'm getting so tired of x' ing out of all of those visual basic windows in MS Access code view.
Had the same problem with A2K.. now using Office 365... have they added a function key or key shortcut for this yet???
I can't believe you experts deal with this problem..do you?

Thanks..p
0
I have opened Microsoft Word 2016 multiple times over past months using "Run as administrator" and clicked "Remove" on the following add-ins.

Add-ins Removed from Word
Despite manually removing the add-ins multiple times, I am constantly being frustrated by those add-ins re-installing themselves whenever Microsoft Office receives an update from Microsoft. I've noted this happen several times now and can't seem to find a way to prevent it from happening.

The same behaviour occurs in both Excel and Outlook - removed add-ins reinstall and reactivate themselves. Unsure of other Office applications as I rarely use more than the three discussed here.

Other add-ins in Outlook include WinZip Courier, Avast Antivirus Pluggin and others. There is no pattern relating to the add-ins themselves. If an add-in is available, upon recieving an update for Office 365, everything is re-installed after the update and re-activated.

Does anyone know how to stop this annoying behaviour once and for all? What am I missing?

Regards, Andrew
0
C++ 11 Fundamentals
LVL 12
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Hello experts,

I have the following graph:

2019-01-19_20h39_03.png
I am trying to add a zone scale as reported manually:
-0-5 good
-5-15 fair
-15+ poor

I supposed that this can be add through y x bar. If scale zone is not possible we can define just lines at 5 and 15.

If you have questions, please contact me.

I attached dummy file.
Test-plan-2.xlsx
0
Insert a vertical lookup function in cell H5 to display the amount of down payment for the first client based on the membership type.
0
Hi,

We have a problem on Sharepoint 2013 with Office online server.

Everything is working well except powerpoint :
zef.PNG
Here the ULS errors :

01/18/2019 18:47:41.54 	w3wp.exe (0x38BC)                       	0x30DC	Office Online                 	PowerPoint Animation          	a23u	Monitorable	Pipe application exception caught when executing web method handler: Microsoft.Office.Server.Powerpoint.Pipe.Interface.PipeApplicationException: ErrorWacConversionWorkerException     à Microsoft.Office.Web.Common.AsyncResult`1.WaitForCompletion()     à Microsoft.Office.Server.Powerpoint.Web.Services.PptViewingService.EndGetImageResourceInternal(IAsyncResult result)     à Microsoft.Office.Server.Powerpoint.Web.Services.WebMethodExecuteHandler.ExecuteInternal(HttpContext context, Func`1 webMethodHandler, IPerfEventHandler perfEventHandler, Boolean fCheckWebIsEnabled, Boolean fSetAffinity)  WacConversionResultErrorInfo; ItemRetrivalStatus: ConversionError; ErrorCode: ErrorWacConversionWorkerException; ConversionResult: WorkerException;.	fe2c73fb-00b5-4023-8304-5aecf0b58021
01/18/2019 18:47:41.54 	w3wp.exe (0x38BC)                       	0x30DC	Office Online                 	PowerPoint Animation          	apvsm	Monitorable	Exception Translated to ErrorCode: ErrorCode=ErrorWacConversionWorkerException, ErrorTitle:{webappfull}, ErrorMessageDésolé... {webappshort} ne peut pas ouvrir ce document, car une erreur s’est produite. Pour afficher ce document, 

Open in new window

0
How to fix this. It opens on another laptop though but if you try to save it over you get back the same error.

What could cause this and how to fix it ?
33D0BACE-20B9-4FCD-926C-2D18197198A.jpeg
0
outlook 2013 doe not remember password when boxed is checked.

Laptop user that has been added to the domain. Connects at office every morning on corporate WiFi and is prompted for outlook password every time outlook is started.
0
i see some templates here.
i downloaded zip and unzipped and copied those contents and placed at
C:\Users\xyz\Documents\My Shapes

http://softwarestencils.com/uml/index.html

any other visio similar templates to reuse existing shapes and sequence diagrams etc

please advise
0

Microsoft Office

66K

Solutions

42K

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.