Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Countless times I have deleted junk and other unwanted or no-longer-wanted emails. I have then gone on to "purge" them under the "recover" option. All then appear to be purged, since the folder is reported as "empty".

However going back later and checking whether this has really been done, reveals that all - (including so-called previously deleted) emails have appeared again in the Deleted folder.

Any informed explanations for this anyone ?

Thanks, krakatoa.
0
Free Tool: SSL Checker
LVL 9
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have an Excel 2013 spreadsheet with over 3,000 entries.  The spreadsheet has customer numbers and Company Names (see attached sample) - my original spreadsheet has many more columns but I tried to simplify for explanation purposes. On the sample I have attached there are five customer numbers (3, 4, 5, 6, 7) and only two company names.  I am trying to find a quick way to determine what customer numbers are listed with both companies.  So in my example, customer #4, #5 and #7 are the customers that are associated with both companies.  That is what I am trying to extract.  I don't need to know the customer numbers that are only associated with one company. I need to pull only the customer numbers that are listed for both companies.  Any help is appreciated.  Thank you.
0
how are the steps to put this in any file i need
DATADATE--10-RR.xlsm
0
i have this file  working  but need paste the data in destination

after click the button
need paste the data in destination
wktaSSS_v2--1-.xlsm
0
I'm looking for instructions that show how to use the free version of Team Viewer to allow Windows & Mac  computers to be controlled remotely.
0
Windows 7 IE11 opens and closes automatically.  I went to the Action Center Problem Details and saw this message from 7/7/17:  

Description
The program IEXPLORE.EXE version 11.0.9600.18698 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
 Process ID: 2670
 Start Time: 01d2f744967e20af
 Termination Time: 0
 Application Path: C:\Program Files (x86)\Internet Explorer\IEXPLORE.EXE
 Report Id:

Can anyone help on how to get IE working again?
0
Client uses Word 2016/Outlook 2016 has an Office 365 subscription. The spell checker keeps forgetting learned words.

File has been deleted and recreated. Rogue entries deleted from registry. Re-creation of RoamingCustom.dic has been invoked through software via Proofing Tools set up menu.

Word 2016 open, spell checker taught new word. RoamingCustom.dic file time stamp changes indicating file has been touched. Outlook 2016 also open, e-mail composed and newly added word is spelled correctly and not flagged as wrong.

Outlook 2016 e-mail composer using RoamingCustom.dic also taught new words. Time stamp of RoamingCustom.dic modified and Word 2016 also knows newly learned word.

Both apps, open at same time with AppData/....RoamingCustom.dic file being modified to prove both applications are teaching the new word to the shared dictionary file. So both applications are clearly touching the same file modifying it, updating it and using the shared file.

Works for a few days then stops working. What is causing the failure?

Many thanks.
0
We're talking an ASUS net book (tablet  that can detach from small keyboard) Modal T100H Mobile Dock.

Somehow I have managed to turn on the number lock so that instead of a "j" I get a "4 or some such, and so on for the letter set that prints numbers when you set it to. Except that I did not do that intentionally.

There is NO number lock key on the keyboard.

In case you did not get that, let me repeat it....THERE IS NO NUMBER LOCK KEY ON THE KEYBOARD!

I say this only because I did some searches and found that as the answer.

So experts, what's the solution?
0
i have an sheets some data is mark with the color can i  copy just by the color ??
0
This procedure --which I attached to a command button-- isn't working.

I'm really trying to make it work with an IF Then Else to see if it can be done. (see attached workbook.

Private Sub cmdAdd_Click()
Dim rowcount As Double
Beginning:
rowcount = 9
If rowcount = Empty Then
    Cells(rowcount, 1).Value = frmEmployeeInfo.txtEmpName.Value
    Cells(rowcount, 2).Value = frmEmployeeInfo.lstEmpDepartment.Value
    Cells(rowcount, 3).Value = frmEmployeeInfo.txtEmpEarnings.Value
    
    Else
    rowcount = rowcount + 1
End If

End Sub

Open in new window

forms-in-excel.xlsm
0
U.S. Department of Agriculture and Acronis Access
LVL 4
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

need go to the las record of data

but data will increase so it will change as time goes

in this case F1211
Gotolast.xlsx
0
What are the best commercial programs for recording all keystrokes on a Windows 10 64-bit computer?

I will be installing this on my own computers since I'm constantly typing things that need to be logged.

I won't be using this for any sneaky or dishonest purposes.

I need this program to be able to run in the background without displaying any prompts or messages and for it to be able to run without being detected by Symantec Antivirus or Malware Bytes. I need to be able to configure exemptions so Symantec Antivirus and Malware bytes will allow it to run.
0
I want to remove the #NUM! errors from my list, I've attempted to construct a IF(ISERROR) condition but have been unsuccessful. Any advice would be appreciated.

=INDEX($C$2:$AG$500,SMALL(IF(INDEX($B$2:$AG$500,,MATCH(K$505,$B$1:$AG$1,0))<>"",IF($B$2:$B$500=$B506,ROW($B$2:$AG$500)-ROW(I$2)+1)),1),MATCH(K$505,$C$1:$AG$1,0))

CLOCK NO      1      2      3      4      5      6      7
279639      B      B      #NUM!      A      A      A      A
416848      A      A      A      C      C      C      #NUM!
797413      A      A      #NUM!      C      C      C      C
0
Hello,  the following selects a range, if it exists, whether there is only one, or a bunch.  However it has a row = 2 in it.  How would I rewrite this to write that out of it?  It sort of confuses me.  If found it in a google search.  Its like saying, if the cell in row 2 is blank, the activecell (which is k4) is blank too?

row is used 3 times in this in this sub.  How can I do the same thing without using this row that dim as Integer??
Looking for some assistance rewriting this.  Please advise and thanks.

    Range("K4").Select
    If ActiveCell = "" Then
        MsgBox ("No Config Profiles found to ALE")
        Exit Sub
    Else
        Dim row As Integer
        Dim value As String
        row = 2
        Do
           value = Cells(row, 11).value ' 11=column K
           If value = "" Then
              Exit Do
           End If
           row = row + 1
        Loop
        Range("K4:K" & (row - 1)).Select
    End If
    Selection.Copy

Open in new window

0
Dear Experts,

I have a user which started to have an issue with opening ppt files this week over vpn.
The strange thing is it's only happening with ppt files, pptx are opening fine.
If I copy the ppt file from the Shared drive to the desktop it takes 3-4 Seconds to copy and around 10 seconds to open.
If I open the same ppt file directly from a network share it takes around 3-4 Minutes to open or Powerpoint is even crashing.
The same files are opening fast when on the Office network.
I'm running out of ideas what could be the issue.
I tried the following until now:

- repair office
- Adjust MTU of the Wifi adapter
- start Powerpoint in safe mode
- disable all Add-ins
- Add network share in the trust center to trusted locations (including subfolders)

It's still the same after all this.

the following is used:
- Windows 7 64 Bit
- Office 2013
- Cisco Anyconnect

Best Regards and many thanks in advance for any input,

Patrick
0
HERE MY LIST OF NUMBER
N3DTA.xlsx
0
Hi,

We started to implementing Continuous Integration in our company and for one of our products, we implemented the gated check-in in the MAIN branch, this way it will only be committed to TFS if it'is successful. Whenever we got a build error we were used to connecting to the build server and try to build it manually for debugging process only.

In our last code change, we noted that the source that was copied into the build agent folder did not have our last changes in the src folder, even though the result in the bin folder was right.

One of our theories is that it will create a shelveset that contains a merge of latest TFS version and the latest checked in changes, and it will build in this context. It would explain the outdated src folder and the updated bin folder.

Is it the normal gated check-in behavior or is it a bug? How does it work in detail when interacting with the build agent?

Thanks in advance
0
Dear Team, I just want to confirm these concepts. We are deploying a new Exchange server and in the migration phase. As our understanding, there are 2 options at the moment:

OPT #1. Collect all PST files from users, create new email accounts in a New Exchange server and everyone will have to open their OLD PST file to access the old emails.

OPT #2: Collect all PST files from users, create new email accounts in a New Exchange server and IMPORT their OLD PST files to the Exchange EDB, then everyone can use their accounts to access OLD emails normally.


Am I right to think that:?

1. Open PST files via MS Outlook is just open the file and nothing happens to Exchange EDB database ?

2. Import PST files via Exchange Management Console will import email data from PST file to Exchange EDB database , then increasing its size (by the size of PST files) ?

If we have about 2000 users, which option will be better?
0
Hello Everyone, Im looking to create an MSI file for citrix so i can deploy to multiple computers at once. i have downloaded a .exe to MSI converter and that did not work. ive also tried following the instructions on Citrix's website at the cmd prompt yet i get an error that citrixrecevier.exe is not a recognized as an internal or external command....  
is there anyway to convert or deploy to multiple computers without creating a GPO on the servers?
If possible i would like to use Desktop Authority from Dell or PDQ deploy.
0
Will your db performance match your db growth?
LVL 2
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Whenever i drag a formula in excel, I have to double click the cell for it to actually calculate correctly. For example if i drag a formula from one cell that's total was 12 all the cells will say 12 that i have dragged the formula to even though the answer should be 29, or whatever.  I was wondering if there was an easy fix because this can be tedious.
0
Please provide me with the steps on how to create a bootable Windows OS that will boot from a USB drive so that I can access the computer's Windows 10 OS to run antimalware and antivirus programs.
0
Sir I have given a omr based exam all information in omr fill completely but one point we not fill in omr sheet this is- total no of answer attempted by candidate ..so please tell me my omr sheet will be evaluated or not please sir reply
0
In Cell A9 I have a date

In Cell S9 I have a cell that contains text "Minor Risk Breach"

In Cell T9, I have a formula =IF($S9="Minor Risk Breach",$A9,"")

The result shows as Jan (Which is what I want it to show)

In  a hidden Cell I have the Formula =COUNTIF($T$9:$T$600,"Jan") but this is not showing how many times that Jan appears in column T.  I am assuming it is reading the formula and not the result in the cell.

I have tried this formula In Cell T9 =IF(S9=”Minor Risk Breach”,TEXT($A9,"mmm"),"") but I am getting #NAME?

I can get a formula to retrieve the date if Cell S9 has a number but not when it is text

I am trying to calculate the number of times that a minor risk breach occurs in the month, based on the date in cell A9

Thanks in advance for any help. I am trying to set this report up ready for a meeting on Monday

Regards
Dot
0
In an excel sheet I want to have scores added up by contestant - say in B1 is the persons name 'Billy Brown' and in C1 is 10.  So the formula has to cycle through the B and C column then add only the scores for that persons name.  It would be good if it could put the persons name in say D1:D5 and their total scores next to their names in E1:E5
0
I believe SCOM 2012 does include configuration manager 2012 as well

Is it same as SCCM 2012? in that situation SCOM 2012 does the work for SCCM as well.

i believe SCOM 2007 does not have this feature

Is there any good documentation highlighting difference between SCOM 2005, 2007, 2012, 2016
0

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.