Normal one minute, completely unusable the next; last evening my inbox inexplicably disappeared, and along with new folders appearing out of nowhere, a few folders, including my junk mail folder, were duplicated as well (the junk e-mail duplicate was spelled
“Junk Email”, missing the hyphen). Folder view (ctrl + 6) is also missing the inbox. Meanwhile, my secondary email account is completely unaffected. Malwarebytes has ruled out any viruses, and the website version of Outlook has nothing weird going on, so I
genuinely have no idea what happened here. What’s going on, and how do I reverse this and restore my inbox?
New computer. Installed Office Pro Plus 2016 (home use program, used b/u disc). I get a cover page asking for my activation code upon each opening of any App in Office. I can ‘x’ out of that cover page and get directly to the app. Opening Word, Account,
File, it shows that ‘Product Activated’ for my Office Pro Plus 2016; yet each time I open Word, or any other App, I get the same cover page requesting the code again. How do I make this new computer lose the cover page? Read More
When I open Outlook I get a message to confirm my account. I key in my account name and password and then I get the message Account updated. I click OK and then I get a message that say’s ‘Microsoft can’t find your license for this application. A repair
was unsuccessful or was cancelled. Microsoft will now exit. I have been using Outlook on this computer for the last 6 months when I paid my license fee. Why am I having this problem?
Thanks for your help. Please respond to *** Email address is removed for privacy ***
It’s how to explain this, at the moment i have a Form that asks the user for input into any number of text boxes, the criteria i have used is ‘Like “*” & Form![NameofTable]![NameOfField] & “*” , a button is clicked to run the query, and the results are
drawn into my Form (this form was created by using the ‘save as’, option to copy the result table/datasheet’ and ‘saved as’ a Form), great this is what i want the Form showing the results, the user can then click on one of the results which take them to the
correct input Form
My problem is, when the button is clicked the query runs, but the query result table/datasheet open too, i don’t want this to happen. Can i stop the query from opening it’s own result table/datasheet.
Have i gone about this the wrong way? , Help would be most welcome, i’m quite a novice at this but i am getting there (I think, I hope, well i can but dream) [i didn’t want to use the default parameter way where a popup would popup for each field in the
query that needed input from the user]. Oh! can be a bit presumptuous and ask if there is an answer to my problem it’s not through reams and reams of code and if possible, by not using a wizard. This is also the very first time I have ever use anything like
this so please be gentle
In the given table i want to count that If type is Single than how many unique values are there in Value column. So can you please suggest me a formula for that ASAP.? Read More
I have a problem with changing the format of Excel cell. First I got a file from my colleague and I wanted to change the format of some information from ‘time’ to ‘text’. But even I changed the format and the Excel is showing it is changed, Excel is asking
me to use the proper form for the ‘time’, as you can see below. I
hope to fix it as soon as possible because it is related to their salary.
I have a questions about IF formula.
I want if cell E9:E150 is Oil, then som M9:M150 only the oil, the answere i want in cell i5
But the formula i use gives me a #name? error
Note: cell E9:E150 are dropdown
See picture below, can anyone help me with this formula?
Tried to using the application outlook 2016 from microsoft office, cant setup the account, etc yahoo.gr, cant setup it, or other account, after i has windows live 2012, cant extract email from this, stoped to extrac after 9 email, with exhange (to format
this to pst files), i dont now how to extrak the accounts & contacs and move to outlook, Pls help me Read More
Every time I start a Microsoft Office application, a prompt appears that says Microsoft Office can not find the license to run this program. How do I fix this? Read More
I am facing this problem for the last five days with WORD 2016 only, When I click the “OPTIONS” in WORD 2016, it hangs and stops responding. I have tried every possible way to troubleshoot WORD, Followed all the instructions on Microsoft regarding WORD issues,
Uninstalled and Reinstalled, Repaired, and Updated Office But still the problem is not resolved. Screen Shots also attached. Again mentioning this, It only Happens with WORD 2016, Other Office Applications just work fine and smooth. I have to work with some
important documents on Word, and my work is being delayed due to this problem.
Any help in this regard will be highly appreciated.
So i clicked save as and then browse (once – no need to double click this i learned ..if u do it dings)..
and then it automatically goes to This PC and under that Windows (C).
How can i get it to go to the quick access area so i dont have to navigate to where i want to save the file to and take more steps than i need to? Doesnt seem to be a way to change where it goes when u hit save as and browse. Any way to change that destination?
I seem to be unable to activate my office license because “specified Product Key has already been activated the maximum number of times.” This is rich considering the last 4 re-installs were due to a problems with microsoft products (dead surface, corrupted
windows user profile, and then battling install issues with an older access runtime which apparently has to be installed in exactly the right order). So after this extended nightmare I am supposed to buy another license?
Great business model Microsoft, build terrible products that requires constant reinstall of operating system and/or software, and then ask customer to purchase more licenses because they have exceed the number of allowed actications?!
I got nowhere with phone support and was disconnected from chat. I really wish there was a good alternative to Office because I hate to give Microsoft another cent.
Has anyone had any luck getting a product activated after exceeding number of allowed activations? How?
I am able to complete all steps for a mail merge until finalize. At that point Windows stops responding.
I am able to print, but I want to be able Edit Individual Documents under the Finish & Merge option and also save.
I originally was using 2007, but when that did not work I signed up for the free trial and downloaded the most recent software. It still doesn’t complete the merge to a point where I can save my document.
I created folders that I want to delete but when I delete them, they re-appear. I’ve seen several posts related to this bug. Some solutions say to run the scanpst.exe on the .ost and .pst files because they are corrupt but I don’t have and AppData file
under C:\Users\user\AppData. Any ideas where these .ost or .pst files are?
Or any other suggestions? These files are not on my phone or if I logon to my email on the internet. They are just in Outlook 2016.
I am trying to create a new training tracker for work. Basically what I need it to do is when a Date is put into a cell next to a person’s name I need it to change the color of a cell on the next sheet to a color, then when another date is entered in the
next cell next to their name I need it to change that same cell on the next page to a different color. How do I accomplish this? Read More
I have ms office pro 2016 desktop with latest update 16.0.7167.2040
Doesn’t Show the New Functions (Text join,ifs..)
I used this method:
To do that, press the ‘Windows + R’ key on the keyboard.
In the Run open box type in ‘Excel /safe’ and hit ok
But no answer.
Please help me
I used to use the UK and Canadian dictionary and may have added some spellings in such as ‘organiSe’ and ‘realiSe’ instead of using Z for the Canadian options. I have since deleted my additions and only want the Canadian spelling now. MS Word 2016 is still
saying that organise is ok even though that is not the Canadian spelling.
Can I re-install the Canadian dictionary? I deleted it from languages and put it back in but the issue still remains. I also deleted ALL of my exceptions. Spell check IS working and I have tested it by adding an extra letter in the misspelled word.
How can I correct this?
I want to Remove the actual Header… the Physical Space it takes up at the top of the document!
I am not trying to just remove the Header Text; but the entire use of Headers in the Document.
I want to recover the space the Header takes up at the top of the document.
All I have been able to find… relates to removing the Text in the Header… not the Header!
Thanks for any help you can give.
IS there a way to take a large number list, say that goes from 1 to 10,000. and have it converted from 1 to 3, once it hits #4, start over at 1.
Would be nice if I didn’t have to manually do it or set the number value over every few lines.
Excel VBA Macro to import large .txt files into Excel. Macro stopped working, no longer creating multiple .txt files, stops at 1 sheet.
This Macro was running fine on, and suddenly without reason, it is no longer working. I am copying a 350MB text file over to Excel. When I run the macro, it stops at 37850 KB, then the macro just stops. Normally if I am in file view, I can see the Temporary
.txt files being created, but after the first .txt file is created, now the script jumps to the end and deletes the temp .txt files without copying the rest.
Here is what I have. . Does anyone see what might be going on? I copied the desktop as well as the VB Macro Project screen, so you can see where everything stops. The file I am working with is the OcwenLS_789.txt
Const HelperFile As String = “OCWE”
Const N As Long = 700000
myPath = “C:\Users\MarcusReynolds\Desktop\”
myFile = “OcwenLS_789.txt”
Dim WB As Workbook, myWB As Workbook
Set myWB = ThisWorkbook
Dim myWS As Worksheet
Dim t As Long, r As Long
Application.ScreenUpdating = False
‘split text file in separate text files
myFile = Dir(myPath & myFile)
Open myPath & myFile For Input As #1
t = 1
r = 1
Do While Not EOF(1)
Line Input #1, myStr
If r > N Then
t = t + 1
r = 1
Open myPath & HelperFile & t & “.txt” For Append As #2
Print #2, myStr
r = r + 1
For i = t To 1 Step -1
Workbooks.OpenText Filename:=myPath & HelperFile & i & “.txt”, DataType:=xlDelimited, Tab:=True
Set WB = ActiveWorkbook
Set Rng = ActiveSheet.UsedRange
Set myWS = myWB.Sheets.Add
myWS.Name = HelperFile & i
Rng.Copy myWS.Cells(1, 1)
‘Delete helper txt files
Set Fso = CreateObject(“Scripting.FileSystemObject”)
Set Fldr = Fso.GetFolder(myPath)
For Each Filename In Fldr.Files
If Filename Like “*” & HelperFile & “*” Then Filename.Delete
Application.ScreenUpdating = True
Office 2016: Microsoft office cannot find your license for this application. A repair attempt was unsuccessful or cancelled. Microsoft office will now close
When I go in to any office app on my computer, a message pops up saying “Microsoft office cannot find your license for this application. A repair attempt was unsuccessful or cancelled. Microsoft office will now close.”
Last year when I bought my computer, I bought a one year subscription to office. When my subscription expired, I went to my IT desk at school, and I got in no problem, now several days later I can’t do anything with office, and I need it for school.
Original Title: Office 2016
I have followed the steps to create a .csv file export file from Windows Live Mail.
Then I have followed the steps to import that file int the address file of Outlook 2016
I have tried it 3 times and when I check the various address files of Outlook 2016 they are all empty.
If I can’t get this to work I will have to return the product. I got Outlook 2003 to import properly but not Outlook 2016.
I uninstalled Microsoft Office 365, which came with new Microsoft Surface Book.
Then, I installed Microsoft Office 2016 and activated it by using License Server in domain.
When I started Microsoft Outlook 2016 and a windows showed and asked to buy Office 365.
It is very annoying.
Would anyone please show me how to stop it?
Does Microsoft Project 2016 have an easier way to export Resource Usage Data (lists resources, date, and hours worked) into Microsoft Excel, then on previous editions? Reading earlier posts it appears that using previous versions of Microsoft Project,
this was a complicated task. Read More
Outlook.com email now routing to Facebook and LinkedIn contacts folders rather than Inbox – Outlook 2016
I never had folders in my favorites view for Facebook or LinkedIn, but suddenly today all my Outlook.com email is routing to newly created (not by me) Facebook Contacts and LinkedIn Contacts folders which magically appeared in my favorites view. There
is now nothing in my Inbox and all my sub-folders have been pulled under these new folders as well. It’s a real mess. Any way to fix this? Read More
creating a executable only version of a database created in access 2016 (.accde file) running Office365plus
How do I create an executable only version of a database created in access 2016 (.accde file) running Office365plus. I am an old access programmer and have been retired for over 10 years. I am donating my time to create an Access application to automate
management of emergency response teams dues to the extreme flooding in south Louisiana.
In my old version of Access 2007 there was a menu option to create a runtime version of the database. Is there something like that in Access 2016. If so, I can’t seem to find it.
Greatful for you help. Thanks
The Android Contacts app is very weak and cannot deal with “Company name”. You end up with a list of “Unknown Name” contacts because the Outlook.com name field is blank for a company. On People.Live.Com when sorted by Last Name, you get a similar result,
a long list of numbers with no identification. So, the Android App is simply reflecting that.
Is there a contact app that allows sorting by the File As field as set up in Outlook?
I am attempting to use Excel 2016 Home and Office, however every time I open up an earlier file such as Excel 2010 it won’t let me save. This is the error message I get:
I have also clicked everything on for Open and Save in the Trust Center. Rebooted both the application and the Laptop and still nothing.
Looked for the Policy solutions…I cannot find anything for Office 2016 and Windows 10. The only thing I can do with this office package is create everything from scratch. So any advice?
In Outlook 2016, I have a UserForm which includes a Listbox and the below event to start Drag:
Private Sub ListBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Dim MyDataObject As DataObject
If Button = 1 Then
Set MyDataObject = New DataObject
Dim Effect As Integer
Effect = MyDataObject.StartDrag
When I execute the line of the StartDrag, the program clashes.
The error states: “Automatation Error. The object invoked has disconnected from its clients”
I have already unregister and re-register the MSCOMCTL.OCX (the one that is in
SysWOW64 but not the one of SystemX86.
My Inbox has disappeared. In its place is now the folder “Facebook Contacts.” All other folders still remain: Sent, Deleted Items, Junk, etc — Inbox, however, is gone. I first noticed it a couple of days ago. Also, I observed a new notification inviting
me to upgrade to 2016 – which I did. I had hoped the upgrade would have fixed the issue, but it did not. I’ve researched the problem without any luck thus far. Help!
I am having problems when I want to send a document in Excel and word as when I click to send as an email windows live 2012 keeps opening up as the email client and I was told that that email client will not work anymore with windows 10. Can anyone help
me as how I fix this? Read More
I have just had to have my hard drive replaced and in doing so had to re-purchase Microsoft office.
unfortunately I now have Windows 10 and Microsoft 16 including Outlook 16.
I have spent all day saving the few messages that were saved and retrieved over the last month while the machine has been down and filing them in folders that i have created. Now some of the folders have disappeared completely and I cannot find any of
the mails they have even been wiped from my phone.
one folder I changed the name and suddenly that disappeared but the original name I called it when I created it was there but none of the messages I had saved in there were there.
the others had all just dissapeared along with their folders newly created. However some haven’t and the folders are still in existence and the contents there as well although tempted to put them all back in inbox
OutLook has stopped listing the "Sent" emails for one of my accounts. The primary account seems to be operating properly, however. I have inquired with the system provider on the secondary account and they say their stuff is working properly. Read More
I am using the Insert File Printout feature to take better notes on PowerPoint presentations during class (much easier than PP itself) and am wondering if there is a way to automatically remove the attachment to the file that is at the top of the page after
insertion. If anyone knows how to prevent this attachment, it would be very helpful and save a lot of time when I am doing this for every lecture we have.
Does anyone know if it is possible to turn off page breaks in Word? By default the program chooses a "paper size" and uses that as the background for the document which causes automatic page breaks. This may be great if you are going to print everything,
but, honestly, I print very little of the documents I write. They are almost always reviewed on screen. Having one long scrolling page would work much better. I believe Google Docs works this way. Is there a way to do this in Word also? Defaulting to a print
layout seems so antiquated and it makes reading more difficult when images and charts get bumped to the "next" page. Read More
Any changes I make to pictures in Publisher (2016), be it transparency, color etc. are not showing up when I convert the file to PDF. This just started happening. I have been working with a particular file for 6 months, and suddenly today, the picture
shows up as non-transparent in the PDF, even though I have the transparency set at 81%. I tried playing around with the coloring as well, and same thing. It just shows up as the original picture inserted into the document. I am not doing anything differently,
but I am definitely in need of a fix for this as soon as possible! Read More
I’ve been through the forum but nothing has worked…
Outlook has stopped opening and has the message below.
It won’t open past this, I have one profile and its all I need, I can access email via OW can someone help me with a fix?
Visio is great for creating schematics, diagrams, and so forth. You can add pictures (like outline of your building for instance) into the background and then add details items (like distributed computer networks) which show not only the connectivity of
items, but their physical location. OK Great.
So I have diagram that does essentially that, but suddenly the background picture refuses to show up on any printed view.
- Print preview – its not there
- Save as a PDF – its not there
- Print to a printer – its not there
- View in visio – its there
OK, so I search the forums and I find references to visio 2003 and other useless tidbits about ‘make it printable’. These are neither applicable in 2016 nor correct.
So I take the time to call MS and we spend 90 minutes doing all the basic stuff. Fill options, picture properties… whatever. I have 16 different versions of this file (revisions), 15 of them had worked, # 16 does not now. Even opening the older version,
I has the same problem. This tells me that its not a file issue, but a visio issue. I installed another seat of visio on my laptop and it behaves the same way, it refuses to print.
While on line with tech support, I manage to find the button that controls transparency (thanks visio for hiding under three layers of menu option now…) and I change it to 0% transparency. The image is now showing up in printed documents…. Any change
from 0% transparency, and the image is no longer on any printed document. Now let me remind you all (MS people), that Visio has been working just fine for the last year.
Further, we opened the same document in 2010 and it prints and works just fine.
Im going to first say – I really dont like the new office 2016- and had my computer died would i would not be here on this forum.
Im now on anHP Spectre Laptop -and the scaling of all the fonts seems to be way off.
some fonts on Outlook are Huge! while others are so small _ I cant see with out a magnifier.
How can I set the fonts where I can see what is on the screen
I have created a small database for invoice processing in access 2016 and the invoice (Sub Form) has the following columns:
Description Qty Sold Unit Price Line Total
Example( tent) 01 $2.00 $2.00 ( The line total is a calculated field)
Example( mrty) 01 $2.00 $2.00 ( The line total is a calculated field)
Now I want to insert a SubTotal by inserting a text control in the control source property text box I created on its footer
as = Sum([Line Total]) unfortunately it is returning an an error (#Error).
I have tried = Sum(Nz([Line Total],0)) I still get an error message
What do I do to solve this mystery
- I recently upgraded to Office 2016. Now when I receive an Excel document via email, it opens to the program, I can’t open the spreadsheet. It is not there. I have went options, advanced, general, and checked the “ignore other applications that us Dynamic
Data Exchange (DDE), but this did not solve the problem.
- What else can I do?