Issues with using "TEXTJOIN" function and whole numbers.
Does anyone know of a way to use the "TEXTJOIN" function and be able to bring over whole numbers from a cell in Excel that is formatted to display the whole number with zeros after the decimal point. Example: I have a cell that has the whole…
Microsoft 365 and Office | Excel | For home | Windows
Seeking Text Animation "Red Ants" and "Black Ants" in Microsoft Word 2016
Dear Microsoft and community, I have recently acquired a new computer and made the jump from Office 2003 to Office 2016. [I've hesitated for so long, knowing that the newer versions have the ribbon and no menu option, not a fan of icons but I…
Microsoft 365 and Office | Word | For home | Windows
Importing MDB files in Access 2016
I am working with an Access Application created using Access 2000 that has worked fine with Access 2007 and Access 2010. Access 2016 will open the application but will not allow the importing of mdb files giving the error message that it will not…
Microsoft 365 and Office | Access | For home | Windows
Word will not let me save my documents, keeps asking me to sign in repeatedly
I will write out an entire paper, and then when I go to save it (before it lets me browse my documents and choose a place to save) it asks me to sign into my one drive account. So, I do so. Then I find a spot to save it in, and it asks me again to sign …
Microsoft 365 and Office | Word | For home | Windows
Excel Quick Access Toolbar - Shrink to Fit Button
Is it possible to add a "Shrink to Fit" button on my Quick Access Toolbar in Excel (Microsoft Office 365 ProPlus)? I see just about every feature listed under Customize the Quick Access Toolbar but the "Shrink to Fit" option. I've…
Microsoft 365 and Office
Run-Time Error 3086 - Could Not Delete From Specified Table - No Problem on my system, user has issue
My VBA Code is getting a Run-Time Error 3086 - could not delete from specified table. I don't have this problem on two of my systems (Win 7 Pro with Office 2010 Pro and Win 10 home with Office 2013 Pro). My user is have this issue with two of his…
Microsoft 365 and Office | Access | For home | Windows
Pages become out of order when I print
Every time I print this Word 2016 document the pages switch order. Specifically, the appendices become the first section after the table of contents instead of being at the end of the document (pages roughly 40-95 become 3-58). This happens regardless…
Microsoft 365 and Office | Word | For home | Windows
Unable to edit files in Office online server 2016 as business user
Hello, We are trying to implement a custom WOPI in order to view and edit files in office online. We have successfully deployed the OOS and we can see the discovery xml file. We are able to view a file in office online but, when we try to edit the file…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Unable to reduce license count during renewal?
Its time for me to renew my O365 subscription. My organization had some users leave, so I need to reduce my total license count. However, the option to change my license count is not available. I have reviewed this post and the…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Can't Access Microsoft Publisher even though i have Office365
I have recently bought a new laptop and with it office 365 however I don't seem to have access to publisher. Why is this? and how can I get it as I thought I paid for it all. Thank you
Microsoft 365 and Office | Publisher | For home
Custom Templates in Office 2016
My IT department recently upgraded my Microsoft Office from 2010 to 2016. We are still running Windows 7 platform since many of our state and other necessary programs do not "play well" with Windows 10. Many on-going issues; but the biggest I…
Microsoft 365 and Office | Install, redeem, activate | For home | Other
Remove and Manage Buttons Missing in Connected Services
The "Remove" and "Manage" buttons are missing next to my Connected Services. How do I get them to appear?
Microsoft 365 and Office | Install, redeem, activate | For home | Other
Full Justification makes spaces between words uneven - how to break the last word of a line in two?
I am writing a long document - a collection of stories. With a full justification on both sides, spaces between words are uneven, often stretched out to be justified. How can I break the last word of a line so that the rest of the characters in the…
Microsoft 365 and Office | Word | For home | Windows
Powerpoint to display slide based on the time of day
I have a room reservation slide show. Each slide has the meeting name, the room, and the time of the meeting. Is there a way to have the PowerPoint only show the slides with times after the current time? For example, it's 7 am and I have times that …
Microsoft 365 and Office | PowerPoint | For home | Windows
Runtime error 3048: "Cannot open any more databases"
Hello, Somebody please help! This runtime error detailed below is trying to mar my effort on a database that have taken me a long time to create. The error is: "Runtime Error: 3048: Cannot open any more databases" It often comes up anytime I…
Microsoft 365 and Office | Access | For home | Windows
How do you change the eraser type
I am using onenote 15.28.2 on IOS on an IPad pro 9.7 and it doesn't let me change the eraser type off of the stroke eraser. How do you switch it to an eraser that is actually useful when in class taking notes, drawing diagrams and so on. I need a…
Microsoft 365 and Office | OneNote | For home | Windows
VBA Code to Select "Yes" in Yes/No dialog box
Hello I have below VBA code: Dim Text As String Text = "D:\Folder\Text" ActiveSheet.SaveAs Filename:=Text, FileFormat:=xlTextMSDOS End Sub Above Macro is stopped because "text" already exists in D:\folder as per dialog…
Microsoft 365 and Office | Excel | For home | Windows
OK button on the Pivot Table"Add Measure" dialogue box is grayed out
Had no problems until today adding new measures to fields in a pivot table. Now I cannot add any new measures although any existing expressions still function normally. I'm using Excel 2016 Student/Home version in Windows 10. Any thoughts would be…
Microsoft 365 and Office | Excel | For home | Windows
increase Barcode size in word 2016
hi everyone. im currently using a Mergefield to create a code 39 barcode in word2016 for a mailmerge. { DISPLAYBARCODE "{MERGEFIELD Barcode }" code39 } does anyone know how i can increase the size of the barcode generated or the length to…
Microsoft 365 and Office | Word | For home | Windows
Power Point Error when inserting Icons
I am trying to insert from the ICON tab in powerpoint in 0365 but its giving me the following error? How do I fix this to be able to import icons?