Excel Paste Special Dialog opens off center
PROBLEM: When I use "paste special" to add data to an excel spreadsheet, the dialog box opens off center. When running two monitors, this causes it to bridge across onto the other monitor, and on a single monitor, to open at the edge of the…
Microsoft 365 and Office | Excel | For home | Windows
Print problem with logo
Dear all, I have a document that contains 4 pages. When I print it on both sides (long edge), content on second page prints shrinked to the right. Pages are all in portrait mode. We are using Lexmark mx310dn and this happens on two same devices. …
Microsoft 365 and Office | Word | For home | Windows
Comma instead of decimal point to separate numbers in a text column (mac)
Hi, I have a numeric keypad that has a decimal point instead of a comma. For my work, I need to have a column formatted as a text column and have some numbers separated by a comma. Ages ago, I was able to change the separator using the languages in…
Microsoft 365 and Office | Excel | For home | Windows
Formula needed Yes or No answer for date range
I need some help! I added a column that needs to show a Yes or No answer. Column O is the date the project was due and column L shows the date the project was completed. The column I added needs to show Yes or No if the project was completed on time.…
Microsoft 365 and Office | Excel | For home | Windows
can't see the subfolders
created 1 public folder and added to Favorites but I can't see the subfolders.?? It takes some time to load or it is an error? Please help
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Access - Disable OnClick Event for a row that has been
I would like to use conditional formatting to disable specific rows (rows where Item=Note in the datasheet below). The problem is that I want certain fields of the same row to have their OnClick event disabled. I thought I could just add an If…
Microsoft 365 and Office | Access | For home | Windows
skype for business 2016 . cannot syncronize address book
rtm build office 2016 on premise exchange 2013 cu 9 on premise lync 2013 server latest cu skype window shows an exclamation mark bottom right cannot synchronize address book skype for business can't sync with your organization's address book right…
Microsoft 365 and Office
Drop down menus stop working after using a macro to copy them...
Hello Guys! I hope you are good, This is my first post, so please be kind with me,and I am not a programmer Objective : I want to make an Excel file where by pushing a button a macro creates a copy of a form with dropdown menus and everything.…
Microsoft 365 and Office | Excel | For home | Windows
Pictures randomly disappear during presentation.
I've created a slideshow with embedded .jpg images. During presentation randomly some images are missing on the digital projector. In the presenter preview the image is displayed. In the momentwhen I run it, it disappears, both in the preview and on…
Microsoft 365 and Office | PowerPoint | For home | Windows
Changes Reappear after Accepting All Changes and Saving a Document in Word 2010
I have several documents on which I have collaborated with a colleague external to my company. When we make changes to the document we have Track Changes turned on. When I attempt to finalize the documents by selecting Accept All Changes in the…
Microsoft 365 and Office | Word | For home | Windows
Microsoft account Associated With both personal OneDrive and a OneDrive for Business account
Hi, when I go to [www.onedrive.com], click sign in and type my email address (my personal private email address ending With @Outlook.com) I get the Message "It looks like <my email address> is used With more than one account. What do you want…
Microsoft 365 and Office
When Word does not close
After I have saved my progress on a word document and then attempt to close it (by pressing X) the word page disappears however, the program remains open while being unresponsive, lagging the computer, and draining battery life. The only way I know of…
Microsoft 365 and Office | Word | For home | Windows
Need a formula for calculating tournament pairings
I am organizing a 4-day golf tournament with 12 players and I am trying to develop a team pairings sheet with 3, 4-man teams having a different make-up each day. I want to build it up through Excel, the inputs are as follow: 1- 12 players 2- 3 teams…
Microsoft 365 and Office | Excel | For home | Windows
How do I remove a field code?
While editing documents I typically use my shortcut keys. first the ctrl A to select all and then F9 to update all the table of contents and captions. Well this time I did a ctrl A to select all but then for some reason I did a Ctrl F9. Apparently this …
Microsoft 365 and Office | Word | For home | Windows
Word 2007 = visual basic environment could not be initialized; Windows 10
I have Windows 10. When I open Word 2007, I get a window that says, "Visual Basic environment could not be initialized." The details note that normal.dotm is either corrupt when VBE6.DLL is wrong version. There is more than enough space on…
Microsoft 365 and Office | Word | For home | Windows
Free\Busy Information - Cloud user viewing on premise user – I get the dreaded slashes.
-exchange 2010 organization -exchange 2013 is set up as the hybrid server -autodiscover.myDomain.com, internally and externally, points to the exchange 2013 hybrid server -hybrid configuration wizard has been run successfully on-premise user - Can…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Organisation Chart in Visio 2013 - changing default color on levels & automatically update shape information
Hello! I am making an organisation chart, and using the default shapes in Visio 2013 Excecutive Manager Position Assistant Consultant Vacancy When applying a theme, it is possible to make Visio color the different levels in different colors,…
Microsoft 365 and Office | Access | For home | Windows
How can I link Word files as objects when those files are on OneDrive?
I am putting together a "master" Word document and would like to include links to other existing Word documents in it--building a TOC later. I am running Word 2016, installed from my subscription to Office 365 Home. All the files I am using are…
Microsoft 365 and Office | Word | For home | Windows
Public Sub vs. Public Function
I have been reading up on Public Function vs. Public Sub, since I am self taught. I, knowing little, put everything I want to share in a Module as a Public Function. For example, if its as simple as Public Function OpenCal() On error goto…
Microsoft 365 and Office | Access | For home | Windows
Keep Source Formatting in Powerpoint 2007
When I copy a slide from one presentation and try and paste it into another, the Keep Source Formatting option is not available. How can I find it?