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]
42
questions
-1
votes
0
answers
28
views
Change Title Bar Color in Microsoft Office 2019 Applications
Is there a way to change the colors of the MENU bar in Office 2019?
I am not taking about the 365 VERSION.
I have read the 365 answer, it does not help.
Maybe I can change them with winaerotweaker?
1
vote
1
answer
15k
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 ...
0
votes
1
answer
42
views
Force Smart Tags and Accelerators to Appear (or to Disappear) in Microsoft Office Word 2019
An issue I have wondered about for years. At times it is mildly iniquitous; at other times it is seriously irritating; and some of the time it is veritably cataclysmic.
Since at least MS Office 2007, ...
3
votes
1
answer
291
views
Indent an Entire Paragraph in Microsoft Office Word 2019 with the TAB key (instead of indenting only a single line)
Long time reader, 1st time caller :)
An inexplicble formatting problem has suddenly arisen in Word which, for some reason, seems to be un-reversible. (It occurred in Word'19, so it might also be ...
0
votes
2
answers
3k
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 ...
2
votes
3
answers
75k
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 ...
1
vote
1
answer
3k
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 ...
0
votes
0
answers
628
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 ...
1
vote
1
answer
298
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 ...
0
votes
1
answer
90
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,...
1
vote
2
answers
1k
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 ...
0
votes
0
answers
700
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.
...
1
vote
2
answers
1k
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 ...
1
vote
1
answer
14k
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?
0
votes
1
answer
2k
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 ...
0
votes
1
answer
4k
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
-1
votes
2
answers
166
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 ...
0
votes
1
answer
5k
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 ...
1
vote
1
answer
77
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 ...
-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\...
11
votes
7
answers
43k
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 ...
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…" ...
0
votes
0
answers
65
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 ...
1
vote
1
answer
194
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 ...
1
vote
0
answers
10k
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 ...
1
vote
0
answers
250
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 ...
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 ...
0
votes
0
answers
461
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 ...
0
votes
1
answer
990
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 ...
0
votes
1
answer
142
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 ...
1
vote
1
answer
487
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....
0
votes
0
answers
61
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 ...
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 ...
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 ...
0
votes
1
answer
2k
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 ...
0
votes
0
answers
192
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 ...
2
votes
2
answers
19k
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 ...
1
vote
2
answers
23k
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 ...
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?
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 ...
0
votes
0
answers
115
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 ...
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 ...