Questions tagged [microsoft-office-2019]

Office 2019 is a perpetual license version of Microsoft Office for both Windows and Mac. For questions about the subscription-based Office products, use [office365]

Filter by
Sorted by
Tagged with
0 votes
0 answers
240 views

Office ODT 16.0.15726.20188 Breaks Offline 2019 CDN

I have a CDN setup on my offline network to update Office 2019 Pro. The ODT setup.exe file on the CDN is 16.0.11901.20000 and has been working since 2019. Recently as of the end of November they ...
JukEboX's user avatar
  • 395
1 vote
1 answer
2k views

Where is "Align at =" feauture to align equations in Word 2019?

I have three equations in MS Word 2019, I want to align them at the equal sign. I found this advice (also here): Type the first two equations in separate equation containers, just as you show them ...
Tomas's user avatar
  • 7,319
0 votes
0 answers
516 views

Microsoft Word Conditional Mail Merge - Bullets in Linked Document

I am creating a conditional mail merge in Microsoft Mail Merge that uses if...then..else. Currently, it is set so that if a letter type is one of several letter types it will go to a specific file and ...
Liz's user avatar
  • 1
1 vote
1 answer
59 views

Embedding a vertical reference line in chart

I am using a combo chart and I have managed to reach as shown below Below is the output that I am seeking. I am trying to add a vertical line for a specific date (say 11th Jul) I googled a lot but ...
Dhruva's user avatar
  • 435
0 votes
1 answer
82 views

Summing data points over a variable range

Personally, I'm facing this problem, but with an added dimension: 2019 2020 2021 2022 January 1,600 1,780 1,860 1,890 Feb 1,600 1,780 1,860 1,890 March 1,600 1,780 1,860 1,890 April 1,780 1,860 1,...
Andy's user avatar
  • 1
1 vote
2 answers
326 views

How to return the cell formula rather than the value

I would like to know if its possible to extract the cell reference from a cell to use to calculate an offset. I've added the below screenshot to illustrate what I am trying to achieve I hope that it ...
robbie70's user avatar
  • 115
0 votes
0 answers
560 views

unable to copy charts from excel to powerpoint office 2019

Domain user is unable to copy charts created in excel 2019 to powerpoint 2019. It's possible to insert charts from excel to powerpoint as images via powerpoint context menu but not as editable charts. ...
r3volutionxxx's user avatar
0 votes
1 answer
1k views

How many licenses do I get when I buy Office Home and Business 2019

I bought MS Office 2019 (Home & Business) and installed it on one Windows computer and 2 Macs. I looked up how many computers I could have and Microsoft themselves said that I had 25 licenses to ...
Gravy59's user avatar
  • 11
-1 votes
2 answers
77 views

Multiple text lines in MS Excel rows by default

I have an excel sheet which I use to write notes. I want either of the two things. All rows to be multi-line (ideally 2 lines high) so if the content doesn't fit it one row, it automatically wraps to ...
user avatar
0 votes
1 answer
2k views

Removing residual office 2010 and 2016 components, icons, etc

I installed Office 2019 HB while Outlook 2016 was still open (I know, bad move). The installation went fine, but now I have remnants of Word 2010, Excel 2010, and Outlook 2016 in the Start menu, and ...
Jake 46's user avatar
0 votes
2 answers
2k views

How can I see Office 2019 for Mac product key

We use a shared account that has 25 licenses associated to it. When we install Office 2019 on a Mac and activate it by signing in with the shared account it lists all licensed products but not the ...
Yasin Akar's user avatar
1 vote
1 answer
67 views

Does MS Teams work with non-cloud version of MS Office?

I purchased Microsoft Office Professional Plus 2019, which is a non-subscription version of Office, installed on my home PC. Skype is bundled with the offering. Because I am not logging into a ...
David Dubs's user avatar
1 vote
1 answer
14k views

How many activations are allowed with Microsoft Office 2019 (Unlimited / FFP/ Box / Retail)?

This link shows how many installations were possible for Office 2010: https://www.microsoft.com/en-us/microsoft-365/blog/2013/02/19/office-2013-and-office-365-installations-and-transferability/ Where ...
OuzoPower's user avatar
  • 214
-2 votes
1 answer
3k views

0x8007000D error while activating office 2019

I installed successfully volume version of office 2019. I was able to activate windows 10 in the same computer I tried to activatve it manually, here is the error: C:\Program Files\Microsoft Office\...
tove lo's user avatar
0 votes
1 answer
3k views

Is this direct link for Office 2019 download legitimate and safe?

Is link below official/legitimate direct download link for Office 2019 professional plus? https://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60/media/en-us/ProPlus2019Retail.img
ZigzagMan's user avatar
8 votes
7 answers
33k views

Microsoft Office Click-to-Run (SxS) using high CPU

There are long running threads of Office Click-to-Run using excessive CPU (ie 30% or more) continuously, as per this post. The solution in that thread works perfectly for Office 2016, however the ...
Dom's user avatar
  • 785
0 votes
0 answers
47 views

Bulk font-replace double-wide Chinese-encoded fonts?

Goal: I'm trying to script or use a built-in operation to bulk replace fonts within a PowerPoint file (a set of files, really). Steps/code: I've found the com object code to create a powerpoint ...
Wolfpack'08's user avatar
  • 1,183
1 vote
1 answer
162 views

Connect Office 2019 to OneDrive without a Microsoft account in Windows 10

I recently upgraded from Office 2013 to 2019. I used to be logged into OneDrive with Office to make use of versioning, and this sign in used to be isolated to just Office and its Upload Center (not ...
Sanoo's user avatar
  • 505
1 vote
0 answers
8k views

Is there a way to force update Microsoft Office Personal 2019 via the command line?

I can't find a way to force update Microsoft Office Personal 2019 via the command line. Normally when office has problems updating I try running the officec2rclient.exe updater executable. However, I ...
wrieedx's user avatar
  • 197
1 vote
0 answers
202 views

What is the VBA equivalent of using an array formula to calculate the max non-blank value of a range?

I have the following array formula in Excel: {=MAX((C9:C44<>"")*(ROW(C9:C44)))} that calculates and returns the row number of the last non-blank cell in a range. I could reference the result in ...
Starnes Student's user avatar
0 votes
0 answers
288 views

How to sign in into Office Pro Plus 2019 using my Microsoft account

I have a Microsoft Account which is already linked to my Windows 10. I wanted to do the same with my Microsoft Office Pro Plus 2019, but I'm not able to sign in using my Microsoft Account. The Office ...
Seynal's user avatar
  • 211
0 votes
1 answer
322 views

How to force Office applications to use the default printer?

All Office 2019 applications refuse to respect the system default printer on Windows 10 1903. How do I force them to? For reference, this is what I've already tried: Set default printer via Control ...
gohanman's user avatar
  • 563
1 vote
1 answer
354 views

Office 2019 Not Updating From Local CDN

I have setup an offline CDN for my clients that are on our offline networks to keep their Office 2019 installations up to date. Initial installation of our Office 2019 installer installs version 16.0....
JukEboX's user avatar
  • 395
0 votes
0 answers
50 views

Shortcut to file browser when saving files

Background: I miss the days when Ctrl-S instantly brought up a file browser with a text box at the bottom for a name and a menu below for file type, but for many years it's only been easy if you want ...
Post169's user avatar
  • 165
0 votes
1 answer
1k views

Make slides with same number

Suppose I have two slides, one says "hello" and the other adds "world". I want both slides to be the same slide number. One way to do that is with animation,so that "world" would appear on the same ...
Amir Sagiv's user avatar
0 votes
1 answer
3k views

"Microsoft sdx helper stopped working" with Office 365 and Windows 7

In the past weeks several of our office computers running Windows 7 64bits and Microsoft Office 365 are randomly displaying the error message "Microsoft sdx helper stopped working". This does not have ...
iceburn_pt's user avatar
0 votes
0 answers
154 views

How to install help for Office 2019 locally?

Recently, I have installed Office 2019 Pro Plus (64 bit). Whenever I click the help button in Access, Word, Excel and so on, a browser window opens and shows a (more or less appropriate) section of ...
Binarus's user avatar
  • 1,707
0 votes
1 answer
134 views

Excel 2019 Corrupting Files - I run Windows 10

I've upgraded to Excel 2019 and run some fairly basic VBA code on files created in Excel 2010. I'm finding Excel 2019 corrupts my files randomly (I save daily versions of similar files where some data ...
imnewhere's user avatar
0 votes
2 answers
3k views

issues activating Office Professional Plus 2019 installed using deployment and retaining only the deployed apps

I have a handful of legit/legal Office Professional Plus 2019 keys. I use the deployment method to install because I only want to install specific apps (Word, Excel, Outlook, and PowerPoint). The ...
IMTheNachoMan's user avatar
1 vote
2 answers
22k views

How to insert two tables side by side in Word?

I want to insert two tables side by side on a single page. The tables are pretty large, 46 rows by 4 columns. I created them in Excel, but found that they can't be imported directly and have to be ...
user avatar
1 vote
2 answers
848 views

Documents open in Office 2010 on PC with both Office 2010 and Office 2019

I have installed Office 2019 on my Windows 10 Pro build 1903 laptop. Later, due to some circumstances, I had to install Office 2010. Whenever I open Word, Excel or PowerPoint files they open with ...
Sumedh Kureel's user avatar
0 votes
0 answers
83 views

How can Office 365 detect my work account

So I have an Office 365 home subscription registered to my private gmail. I recently wanted to try out Office 2019 so I installed Office 2019 in a virtual machine and loged in with my gmail. I was ...
Arete's user avatar
  • 1,371
1 vote
1 answer
13k views

Can I replace Office 365 with Office 2019?

Can I replace my existing Office 365 with Office 2019 on my computer using Windows 10? If so, how do I do it?
Jeremy's user avatar
  • 11
0 votes
1 answer
39 views

Excel printing worksheet

I have a worksheet I work on and when I print pages on one computer the page setup is 100%, but on a different computer the page setup has to be changed to 94% to fit all the data on the page. Why is ...
Murray's user avatar
  • 1
0 votes
1 answer
12k views

Do all versions of Office 2019 have Design Ideas and 3D Objects in PowerPoint?

I am interested in buying Office 2019 Home and Student as I only need Word, PowerPoint, and Excel. Will I be getting Design Ideas and 3D Objects in PowerPoint?
user avatar
3 votes
2 answers
8k views

MS-Office 2019 how to stop syncing to onedrive

Yesterday I uninstalled Office 2016 and installed 2019. I installed only Word/Excel, and no other apps (not OneDrive). When I run Word/Excel - Open, it still shows OneDrive and my email is there: I ...
VSRawat's user avatar
  • 503
1 vote
1 answer
3k views

How can I activate quick actions in the mail message list in MS Outlook 2019

How can I enable quick actions - specifically the delete button - to show in the message list in Outlook 2019? In Outlook 2016 this is definitely possible, but i cannot find how to enable this on ...
twermann's user avatar
1 vote
4 answers
4k views

"Open Recent" menu empty on Microsoft Office 2019 apps for Mac?

On my older machine (High Sierra MacBook Pro, MS Office 2011), apps Excel and Word show a list of recently opened files under Menubar / File / Open Recent. The filenames are then followed by "More…" ...
2540625's user avatar
  • 373
2 votes
2 answers
18k views

Is it possible to install Office 2019 on Windows 10 without uninstalling previous versions?

Upon trying to install Office 2019 (x64 version) on Windows10 x64, it displays a message: "System restart required.. Error Code: 30182-39 (2)" and links to a page suggesting to restart (which I ...
user3645994's user avatar
2 votes
3 answers
73k views

How to update Office 2016 to Office 2019?

I saw that the version of Office 2019 came out, I have Office 365 ProPlus: I was interested in updating, I tried through File> Account> Update Options> Update Now, it says that I have the latest ...
Shai Léger's user avatar