Go Premium for a chance to win a PS4. Enter to Win

x

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

EE,

Curious if it's possible for certain network devices say Juniper, brocade or Palo Alto firewall OIDs that display Anyconnect VPN active sessions, high availability status, SIP Trunks or Chassis Cluster Failover? I'm trying to monitor these in SCOM (Operations Manager) and I need to import these for monitoring.

Thanks in advance
1
NEW Veeam Agent for Microsoft Windows
LVL 1
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Hi All Expert,

Good Day.

I have a user using outlook 365 and one of her colleague emails always went to Junk inbox, I have whitelisted the email address and disable the antivirus add on and still same, the outlook didn't set any rule also. This only happens to one of the email in the same company and domain, raise a ticket to Microsoft and the guy moved the inbox to other server and still same. Appreciate if any expert here can advise me on.

Thanks!
0
My outlook 2013  OOF works for some time for some hrs. and then turns off automatically

It is only me having issues, anything to be checked in my outlook
0
Hello All,

We have a few computers.
On one computer when i click on a control and want to open the Zoom box with Shift+F2 i get a message,
"Add-in missing or was modified". and access locks up.
I already uninstalled Access 2010 and installed it again and it did not help.
Thanks in advance
0
We are seeing this graphic attached to the first character of a file name in SharePoint. What do you call this? Is anyone else seeing  it? Example: new file name
0
I'm currently in the midst of a 2013 to 2016 Exchange migration.  Included with this migration is standing up a new Exchange 2013 servers as part of a storage refresh.  We need to keep our Exchnage 2013 enviroment around for some legacy applications.  I've been using New-MigrationBatch, Start-Migration-Batch, and Complete-MigrationBatch to stage the migration batches to copy most of the data over to the new databases on 2016 manuly complete at the desired time.  This has worked flawlessly for all mailboxes moving from 2013 to 2016.  If the batch contains a 2013 to 2013 migration it appears the associated move-request moves the mailbox and does not wait to be manually completed as it should almost like it thinks the autocomplete switch is being used.  I've gotten around this by seperating out the 2013 moves into a separate batch a leveraging a foreach loop with the New-MoveRequest cmdlet with the -suspendwhenreadytocomplete to overcome this.  I've not come across this before granted most of my migration previously have been 2010 to 2013, 2013 to 2016, or 2010 to 2016 never a mixed batch.  I can't find anything that would indicate this is by design or a bug.  I was wondering if anyone has come across this before.
0
in regards to this question
https://www.experts-exchange.com/questions/29067900/Excel-formula-referencing-multiple-columns-between-tables.html
obviously i have more data then i included in the example, as sheet1 is 90k plus enterys.
and i have a couple other large sheets referenced that are not directly part of the problem
so the information i am trying to retrieve exists on column 3 (C) of sheet 4, i have modified the formulae as follows
{=IFERROR(INDEX(Sheet4!A:O,MATCH(1,(Sheet4!A:A=B8)*(Sheet4!B:B=C8),0),3),"")}

Open in new window

and entered with ctrl + Shift + enter and i am getting no data.
should it matter that sheets 1-4 are from sql data connections? or is there something obvious im doing wrong
0
I need to create a Task Scheduler for 10 pm every day, but if the PC is off at that time, it needs to forgot this event and wait until next day 10 pm.  In other works if the PC is off skit the event.
Right now my script create the event but if the computer is off, the event occur at soon user log on in the morning, I need to avoid it.
Any ideas and thanks for your help.
 
#Create a 10 pm task Scheduler

$taskExists = Get-ScheduledTask | Where-Object {$_.TaskName -like $jobname }

if($taskExists)
{}
else
{
$script =  "-ExecutionPolicy Bypass -file $File"
$action = New-ScheduledTaskAction –Execute "powershell.exe" -Argument "$script"
$trigger = New-ScheduledTaskTrigger -daily -At $Time
$Description = "Shutdowm computers at $Time every day."
$settings = New-ScheduledTaskSettingsSet -AllowStartIfOnBatteries -DontStopIfGoingOnBatteries -StartWhenAvailable -DontStopOnIdleEnd
Register-ScheduledTask -TaskName $jobname -user "theuser" -Password "password"-Action $action -Trigger $trigger -RunLevel Highest -Settings $settings -Description $Description
}
0
Have Exchange 2013 and a few users use OWA instead of Outlook.  All of a sudden the Calendar Notifications and Task Notifications don't work.   Normally 30 minutes before a meeting a pop up would happen and the computer would make a sound.

Now that isn't happening, nothing has changed, and it's across all users on all computers.

All the settings in OWA, options, settings, calendar are correct and say to remind and play a sound every 30 minutes.    The new mail notifications and sounds are still working correctly.
0
I have inserted two shapes ("Plus Sign") in cell z14 of excel 2016. As per my requirement I am using below code for shape copy paste

Range("Z14").copy
Range("D15").activate
activesheet.paste
'------ I am using below code to fetch row number on click of macro ------
 Dim wb As Workbook
 Dim ws As Worksheet
 Set wb = ThisWorkbook
 Set ws = ThisWorkbook.Worksheets("Additional_Details")
 
    Set b = ws.Shapes(Application.Caller)
    With b.TopLeftCell
        cs = .Row
    End With

Above code works fine excel 2016 however it is providing old row number "14" in excel 2013

Please suggest.
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Using Office 365, is there a way to ensure that the default language is ALWAYS English, no matter what language an email is sent in. It seems to turn off automatically when attempting to reply - in English - to an email sent in another language...thanks
0
I have dynamics crm 2016 on premise and I want to extract the solution into dynamics crm 365 cloud. The cloud is brand new.

Is it possible? If yes how to get start it?

Thanks
0
I have been researching various methods.One of interest, is to open the printer queue,sort and copy all files in a folder to the printer queue.This eliminates the looping.Can any one provide vba to accomplish this?

Thanks
0
We are using Office 365 and have setup a SharePoint site.  For some reason, SharePoint stopped allowing me to edit the main page.  I can go into edit mode and I can edit the first header bar, but the three columns are not editable in the GUI.  I can click on the column and select edit source button at the top of the page and edit it that way, but I am not good with HTML and want to use the GUI interface.

I wouldn't be surprised if one of the owners of the page did not add a carrot to the end of their html code.
0
Hi

A user of mine with a roaming profile on a win7 notebook had unexpected results after she rearranged folders an files on her desktop at home (i.e. without connection to the domain servers, notably a Win2008R2 standard server with the profiles$ share) and then back in the office hooked up the notebook to the network and logged in. During the profile sync

- folders and files she had renamed while away from the domain reappeard under the old name so she ended up with the old and the renamed folder
- newly created folders where she moved existing files and folders into remained but were empty after the sync. The moved folders and files reappeared where they had been before.
- files she had modified (content, not name) were overwritten with the old version from the server

it is not clear what happened in terms of logoff/logon during the absence from the server. Most likely the notebook was put to sleep at work, disconnected from the LAN, used at home, then the user loged off, came to the office and hooked up to the LAN and logged on.

My main question is: where do I find documentation about the sync process and the rules that apply in such a sync situation. How does server and client decide which files/folders to copy/keep/overwrite/delete on either server or client during a sync

But of course any help other than that is welcome.

Roger
0
Please provide me with the names of screen recording software that will run in the background within Windows 10 without being detected.

I will only be using this software on my own computer and will not be using it for any malicious or dishonest purposes.
0
I am having an issue on a network share where temp files are being created for example 273890DF.tmp.

In these folders there are office files like word and excel which seem to be linked in some way.

Thanks.
1
Hi

Im using Visio 2016 via Parallels on my Mac. My virtual machine is Win 10 Pro.
I use a Magic Mouse and am having trouble accidentially panning around the document when my finger moves slightly when moving the mouse.
I'd be quite happy to disable Panning in Visio but can't see a way to do it. Another option would be to disable one finger scroll in Parallels 13 but I can't see how to do that either.
0
In SCCM , my Inventoried Software doesn't show IE (except for v.7 and 8) so I when I run query on IE versions, I get no results.
If I do a software report, again, no IE (iexplore.exe)

Is it because the new versions of IE come in as KBs and aren't in add/remove programs?
How can I query for IE 9,10,11?

I tried this:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonTimestamp from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath like "%\\Program Files\\Internet Explorer\\" and SMS_G_System_SoftwareFile.FileName like "iexplore.exe" and SMS_G_System_SoftwareFile.FileVersion like "10.%"
0
[Webinar] Cloud and Mobile-First Strategy
LVL 11
[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Hi all,

Grateful for advice on creating a formula in excel.

I am attaching worksheet for ease of use.

I have two sets of data in two different tabs.

I'm trying to do  a a comparison of amounts based on column A, i.e. check column A in both tabs and if the you find the same number compare the corresponding amounts (total them if need be) and see if they are different. If they are, give me the difference.

I dont mind if this is done in stages.

Thanks
Test.xls
0
hi experts, i would like to make a modification to the attached workbook.
The criteria are listed under the data in the worksheet of the attached workbook.
protect---ifstatement-4.xlsx
0
how can i autodelete particular file name from the system using usb.  for eq if i want to delete file name tally i want all the file should get deleted once i put usb in the system.

moment we insert usb it shoud search file by the name tally or software by the same name it should delete all.


gud luck and best of luck
0
I have an excel pivot table that has subtotals
Subtotal is at the top

Label                   Count of upd_Apps   Sum of upd_Apps
upd_Apps             5                                       499
App1                      1                                        53
App2                      1                                        14
App3                      1                                        80
App4                      1                                       297
App5                      1                                         55
Label                   Count of upd_Apps1   Sum of upd_Apps1
upd_Apps_1                          3                                 565
WINAPP1                          1                                 45
WINAPP10                         1                                131
WINAPP11                          1                                389

Is there a way to hide the detail e.g. App1 or WINAPP1, and display just the subtotal lines?
If not, I will use sumif and countif functions instead of the pivot table.

Thanks
0
Dear Experts,

i need a code,

1- ... prompts the user to open an excel file (source file)
2-... copies the data from  Range(D3:E9999)  of the first worksheet of the source file
3- ... pastes this data into Range(A9:B9999) the first worksheet of the currently active workbook (target file)
4- If there ise data in Range(A9:B9999), pastes copied data into Range(C9:D99999)
5-If there ise data in Range(C9:D9999) too, pastes copied data into Range(E9:F99999)


Thank you very much for your great and professional help.

 Regards,
Hasan
0
Hi

I am facing a really weird issue with my Excel Pivot. As can be seen in the attached screen shot when I am selecting individual months in my pivot table filter I am getting the required data for each month.

But once i select more than one month in my pivot table filter, I am getting a different behavior for my column values.
Forecast Column - Although aggregating but not giving the correct result.
Actual Column - Only displaying results for the latest month (in this case Nov 17).

Any help or suggestions in this regard will be highly appreciated.

Tools Used:
  1. MS SQL Server 2012
  2. SSAS 2012
  3. Microsoft Office 365

Regards,
Saif.
Problem.png
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.