(VBA) Return bookmark name or number from selected bookmark
I wish to create a routine, running from a shortcut, which will interrogate the selected (or next if none selected) bookmark and depending on that bookmark name (or number) go to a predetermined bookmark, whereby the shortcut can repeat the action going …
Microsoft 365 and Office | Word | For home | Windows
Table formatting issues in Microsoft Word
I am trying to format some data tables that I have inserted into Microsoft Word. I am using a preloaded APA style format. There is an extra space within each cell above my text and I cannot get it to go away. I have tried resizing the cell height, but …
Microsoft 365 and Office | Word | For home | Windows
Is it safe to uninstall old Office 2010 updates after installing Office 2013?
About a year ago I installed Office 2013 Professional Plus over Office 2010 Home & Business. In Control Panel/Programs & Features, under Installed Programs, Office 2010 no longer is listed, but under Installed Updates there are 23 updates listed…
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
list SMTP Address using powershell
I have Multiple SMPT Example 123.com 456.com but i need a list of a 456.com only SMTP what will be power shell command get-mailbox | select primarysmtp
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Word Mac picture numbering
Hello, When I paste a picture in a word document and want to insert a numbering (Insert >> insert a legend), the numbering of other picture does not update. Sometimes it even proposes a number that is already used. Is there a parameter I missed?…
Microsoft 365 and Office | Word | For home | Windows
Problem with new Surface Book - removing office 365 and installing office 2016 pro plus
As an MS Partner I have licenses for Office 2016 Pro Plus. My new Surface Book comes with Office 365 pre-installed. My machine is a part of an Active Directory Domain. I need to fully uninstall Office 365 and all registry keys. I have come to this…
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
Cannot download an image from Bing to insert in Word 2016
This happens on all newly re-imaged Windows 10 for Enterprise machines with Office 2016 Plus domain computers, when trying to go to Insert - Online Pictures and find a picture, and click Insert button - a message is displayed: Sorry, we could not…
Microsoft 365 and Office | Word | For home | Windows
Conditional Formatting and Drop Down Lists
I'm creating a very large inventory list that requires a drop down list with multiple locations. I want to color code this list so that when i select a location from my drop down list, all of the cells in that particular line in the table highlight to a…
Microsoft 365 and Office | Excel | For home | Windows
Onenote 2016 will not sync
Onenote 2016 will not sync to office 365 Onedrive. I have tried the following: Removing the notebook and opening it from Onenote online. The notebook appears in the notebooks section but will not sync even when forced. Created a new notebook on…
Microsoft 365 and Office | OneNote | For home | Windows
Excel, Paste Link Returning Zero's, need it to show blank cells not empty
Dear All I'm having trouble with Excel, I have an original table which holds data and does all the calculations. I have created a new work book which holds other data. So I don't have to keep opening all the different work books I have paste linked a…
Microsoft 365 and Office | Excel | For home | Windows
Convert existing Office 365 subscription to non-profit subscription
Our non-profit organization currently uses a paid subscription of Office 365 Business Essentials. We just received Techsoup validation and token for our Non-Profit status. We would like MS to convert our current Office 365 subscription to the…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Barcode Inventory Database Athletic Equipment
I have read through several posts on the forums and have found some useful information. However, I am still stuck. I have been asked to help develop an inventory database for our Athletic Equipment Room. I use access for my the Video Department…
Microsoft 365 and Office | Access | For home | Windows
OData Feed with SharePoint Document Libraries and PowerBI
Using the OData feed in PowerBI I have successfully connected a SharePoint 2016 Online document library to PowerBI. I want a graphical report, bar chart or pie chart for this example, to report on a custom column I have created called document type.…
Microsoft 365 and Office | SharePoint | For business | Windows
Manually configured A/CNAME DNS records being changed without warning
My company currently uses Office 365 mostly for Outlook and internal Sharepoint, and we our external website hosted over at Go Daddy. Our domain's DNS is managed by Office 365, so what we had done was set up A record to point to our Go Daddy hosted…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
MSWord 2013: Revision pane automatically opens when adding or editing a comment
Hi, The "Revision pane" automatically opens when adding or editing a comment. It's annoying because it provides two views of the comments, one in the balloons, and one in the revision pane. I prefer to use balloons only. I can manually close…
Microsoft 365 and Office | Word | For home | Windows
Importing Excel Data into Visio Standard 2010 shapes
Is it possible to import Excel data into Visio 2010 shapes? If so, please provide some guidance (Please don't point me to any online tutorials or guides - I've trawled for hours and had no luck). Also, is there a particular type of shape that this…
Microsoft 365 and Office | Access | For home | Windows
Best Practice - Deleting an mailbox in Office 365 while synced to AD with DIRSYNC/AADSYNC/ADCONNECT
Hi! What is the Best Practice regarding only deleting an mailbox in Office 365 while running DIRSYNC/AADSYNC/ADCONNECT? We do not wanna delete the AD account, or move the AD-account to another OU. We only want to delete the users mailbox. I know you can…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
retrieve current status
Hi I have a pivot table which contain products going through a process (data tab). I wish to create a summaried table (batch summary tab) to show the final status showing 'open' or 'closed' (in column F) which can be retrieved from 'data tab' (in column…
Microsoft 365 and Office | Excel | For home | Windows
How to upload photos from iphone to Sharepoint?
I have taken a series of photos on my iPhone 6s. I want to upload them all to SharePoint without emailing them individually. First, can this be done? If so, how? Second, if it is possible, why is it so difficult to find directions on how to do it?
Microsoft 365 and Office | SharePoint | For business | Windows
Compiling Access Database
Hi How can I compile and debug an access database. Thanks for help. Best Regards