Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

We offer a recycling service and all our customers receive their pick up dates by email once they sign up for a contract.
The data is saved in a worksheet ("RecyclingTax").

I have been asked to display the current week's pickup in a separate worksheet. Obviously, this is a task for the advanced filter.

I do have difficulties making it work. Maybe it is because of the way I put in the criterias?
What is the correct procedure to make it work?

screengrab.PNG
The only reference to a customer in the "RecyclingTaxi" sheet is the customer ID.
I would have to use a VLOOKUP or similar to get the customer's address as well.  
Is it possible to put the filtered data into a table/listobject and then make use of the VLOOKUP?

screengrab2.PNG
Thanks for helping me make the advanced filter work.
sample.xlsm
0
Efficient way to get backups off site to Azure
LVL 1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

transfer cd  to  usb  drive
0
If a cell contains the word "Yes" (with a few other words in it), we want it it to be "Counted". What would the "countif" be?

We actually will be using the formula for excel and for Google Docs. Is that possible?
0
I have a spreadsheet that has different width and sizes columns and  , when I copy and paste the Data into a new spreadsheet the pasted contents does not come as the original, some information shows ########## even though the previous row shows the right numbers.
Thanks a million!
0
I have worksheets named WS1 and WS2. I need to compare Column C of WS1 with Column D of WS2. If both columns contain same values then I need to highlight both the cells of "Column C of WS1" and "Column D of WS2".
Example:
Column C of WS1    
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
2,520.16
30,000.00
210,000.00
650,000.00
10,000.00

Column D of WS2
2520.16
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
30,000.00
1,827,099.63
210,000.00
650,000.00
10,000.00
If values of Column C = Value of Column D then the cell containing same values in both columns is highlighted. My data is not uniform. They may have repetitive values. I am doing it manually right now and it is time-consuming as I have a lot of data to work on. Can you please suggest me.
 I am looking for exact matches for currency amounts and also I want the amounts which has been already matched to be left out. The value in each cell should be matched with only one value of another cell. Leave out the next repeated value to match with next.
0
Hi
 I was just reading a solution explained by our member Saqib Husain, Syed in the thread https://www.experts-exchange.com/questions/28654243/Copy-data-from-Main-Sheet-to-multiple-sheets-based-on-a-criteria.html
 I have a similar situation with excel 2013. I already sent a message to Syed with my request but not sure whether Syed is still active in this forum. Would anyone be able to help?

 I would like to have a Macro in the ‘Task Allocation’ sheet to copy the rows from Column B to Column G and paste it to the individual ‘Team WiP’ sheet as per selection from the drop down list from column A in Sheet-‘Task Allocation’.

 The selection of rows starts from row 6 only as row # 5 is the header

 The entries in the ‘Task Allocation’ sheet need to be cut and copied across to the relevant sheets as per selection from column A.

 As an example, if I select ‘Team 1’ from the dropdown list, the entire data on that row from column B to G need to be copied in to ‘Team1 WiP’ sheet. If there are more allocation to Team 1 from the Task allocation sheet, it would be copied to the next available row in the individual team sheet. Similarly, If I select Team 2, then the data will be copied to ‘Team2 WiP’ sheet. I have 6 teams to select from.

 I have attached my sample file and the code I have which is not working is pasted below

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A6:A" & Range("B" & Rows.Count).End(xlUp).Row)) Is Nothing

Open in new window

0
I have an excel workbook with many rows in a tab called data...  I would like to have another tab called terminated that would only show rows from the data tab where column K = terminated

how is this done with a formula or lookup etc...
0
Hello,
I have an Excel worksheet that I use to track when users are due to take one of their training courses. Currently I am manually inputting the date to expire, but what I would like to have is when I put the date in one cell it will output in another cell that it is due to expire a moth from the due date. Does this seem like something that can be done in Excel?
0
I know connecting to a MySQL Db is notoriously fiddly in Visual Studio. I did manage it though, and have been running a web app successfully for a couple of years, syncing SQL data across to MySQL.

I now have an issue however, which is preventing the app from running. It is a web job scheduled hourly in MS Azure, but it is now failing with the following error message:

[01/02/2018 23:16:54 > 9c069f: ERR ] Unhandled Exception: System.TypeLoadException: Inheritance security rules violated by type: 'MySql.Data.MySqlClient.MySqlProviderServices'. Derived types must either match the security accessibility of the base type or be less accessible.

I have read various MySQL guides and forums with people having similar issues, but still haven't managed to fix it. The latest thing I did was to uninstall all of the MySQL Nuget packages and reinstall them again. It could be there is an incompatibility between the entity versions of each of them, I guess, but I don't know how to work out which versions I should have.

Attached is a screenshot showing the errors I'm getting. It has now resulted in me not being able to open the .edmx file - database designer - in Visual Studio at all. I'm tempted to delete all related files, underneath the WPMySQLDev.edmx branch, but there are so many references and calls to tables in this database that I worry whether we can get them all back in place.

Can anyone suggest how I should go about getting this app back up and working again from …
0
Im wanting to run Onedrive Setup to install Onedrive on my laptop but is a certificate for Onedrive that has the signature "sha256" and "sha256RSA" legit and is it safe to install it?
0
NFR key for Veeam Agent for Linux
LVL 1
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

I have SharePoint 2013 running on Server 2012 R2 Standard.
We have a fairly basic site that consists almost exclusively of document repositories.
I've been trying to configure the Search Service Application to crawl the site for search indexing.
Initially, I followed recommendations found online to create a Default Content Access Account for the Search Service, and gave it permissions to both the SQL databases, as well as full read permissions to the Web Application for the site.

After adding the site as a Content Source, I started a crawl and received the following error:
Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled.

To try and narrow down the permissions issue, I switched the Search Service to use an account with full administrative permissions to the Web Application, and received the same error.

So far, I've tried using an account that has explicit Full Control permissions both on the Web Application and the Site Permissions. As well as Full Control permissions on the Search Service Application itself, same error.
I've tried using the Farm account as well, same error.

I've tried creating a new Application Pool for the Search Service.
I've tried creating a new Search Service …
0
Hi All,

I have this spreadsheet (attached).

I have Mastersheet which contain all the location and the product quantities, now I have to split them in a separate sheet which will be taken by a counter person and key in numbers, now I want the some of A product to automatically calculated and put in the column counted_qty on the master sheet if it possible? can someone help, please.

I have asked this question before and an expert resolved it but when I copy it now it doesn't work. formula is below: (Ignore the last sheet which is MANUAL).

=IF(COUNTIF($C$2:C2,C2)=1,SUMPRODUCT(SUMIF(INDIRECT("'"&SheetNames&"'!"&"$C:$C"),$C2,INDIRECT("'"&SheetNames&"'!"&"$E:$E"))),"")

Thank you.

Regards,
StockTake28122017-WF.xlsx
0
Hi,

I have a program running on Windows 7 Pro 32 bits.  I need to run it on Windows 7 64 bits.

I need help to Shim it with MS ACT.

Thanks for your precious help
Rene

From previous:
https://www.experts-exchange.com/questions/29074623/Need-to-run-32-bits-program-on-a-Windows-7-64-bits.html
0
Hi,
I'm very new to sharepoint.
We are attempting to set up a document store as a List with Document Sets properties for custom columns.

We have a list of projects, the projects can be won/lost/unsuccessful. This is configured as a Document Set column.

As far as I can tell, the Document Set colums are correctly propagating through to sub-items for *documents*.
However, the colum is not being reflected in *folder objects* of the list. Documents within the sub-folder are correctly inheriting.

Why is it that the folder itself is not inheriting the Document Set column data?

We have been through the following article, the documents are correctly inheriting, why aren't folders?
https://support.microsoft.com/en-us/help/2806007/per-location-view-settings-don-t-work-at-the-folder-level-in-sharepoin

Is it possible to disable the column being viewed for folder objects within the sub-folder template?

Any advice greatfully recieved,
Chris
20171220-182048-1.png
0
I have a SharePoint list which has a date/time field.  It displays "2 days ago" and "8 hours ago" instead of the date/time.  Is it possible to turn this off for the entire site, just the list or even for a view?  I was unable to find any way to change this other than JSON formatting.  Learning a new language in order to make a simple change to a date format seemed like the wrong way to go about it.

I read about switching the display type from "Friendly" to "Standard" but was unable to find where to set this.

My question is what are my options for controlling the display format of a date/time column.  My preferred format:
Jan 31 18:45
0
What is a good software program or Outlook add-on to query emails & record contact information in Outlook 2016 contacts?

I have tens of thousands of emails I need to record as Outlook 2016 contacts and am looking for the best way of doing this.
0
Hi,

Has any one see this error:
In the SP shell as an administrator

PS C:\> Register-SPWorkflowService -SPsite "http://xxx.cov.ca"

cmdlet Register-SPWorkflowService at command pipeline position 1
Supply values for the following parameters:
WorkflowHostUri: http://xxxx.cov.ca:12991

Register-SPWorkflowService : Unable to connect to the remote service at http://xxxx.cov.ca:12991/SharePoint/. See InnerException for more details. Client ActivityId :
8e2c389e-ccc3-b051-d34b-7144568e4bc5.
At line:1 char:1
+ Register-SPWorkflowService -SPsite "http://xxx.cov.ca"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (Microsoft.Share...WorkflowService:RegisterSPWorkflowService) [Register-SPWorkflowService], WorkflowEndpointNotFoundException
    + FullyQualifiedErrorId : Microsoft.SharePoint.WorkflowServices.PowerShell.RegisterSPWorkflowService


After installing the Workflow I  cant seem to attach it to the sharepoint site and suggestions ? I saw in the IIS configurations that I cant locate "...91/SharePoint/"
0
I tried to share document on Sharepoint 2016. I could not see user search (no result found). But I can share to try the AD ID.
I attached screenshot. How can I fix it?


Does it relate following issue? How can I find AppID?
In Active Directory, only company leaders should have the 'manager' property set to NULL. As a result of errors, the Active Directory can incorrectly have the 'manager' property set to NULL for other users that can cause a decrease in people search relevance. By specifying the actual leaders of the company, these inconsistencies are not taken into account and the relevance problem is corrected.
Remedy      
Specify the company leaders explicitly. Use the following PowerShell commands: $upap = Get-SPServiceApplicationProxy [appid]; Add-SPProfileLeader $upap [Domain]\[UserName]. Run 'Get-SPProfileLeader $upap' to check whether the leader was successfully added. As a last step, run a full crawl on the content source containing the start address (URL) of the user profile application. For more information about this rule, see "http://go.microsoft.com/fwlink/?LinkID=248249".
sharepoint_user.PNG
0
This subject concerns an issue with sccm 1710. I want my remote distribution points on other subnets to get their updates from the monthly updates from the management point our "software update point" which is located at our central site which hosts all the roles including management and software update point roles. These remote client are setup in their client device settings to "enable software updates on clients" like all the local computers.  When I open up windows software updates on the client computer in a remote distribution group site location, it does not show the option to use either the "managed by your system administrator" for getting Microsoft updates. They only get updates from " online from Microsoft Update". Computers in the local site distribution group do have both these options and will only update from our update server. The remote clients report the correct management point and are members of their own "distribution group" which point to the local distribution point server as their site server. Sorry if this question sounds convoluted. I want my computers and servers that are part of a remote subnet which has a distribution point server in it to get their updates as part of the managed updates from sccm settings and not directly from Microsoft update.
0
Free Tool: SSL Checker
LVL 11
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.

Hello,

This post is a follow-up to two previous threads located here:

Extract certain items from one list to create another list in Excel (closed 2017-10-28)

Understanding a few parts of an array-entered formula in Excel (closed 2017-11-21)

Briefly, the solution to those threads consists of an Excel formula which selectively extracts certain items from a source list and displays the extracted items in a new list while maintaining the correct order of the extracted items. Following is the solution formula and a screenshot from the attached file:

=IFERROR(INDEX(B$1:B$13,AGGREGATE(15,6,ROW(C$4:C$13)/(C$4:C$13=F$2),ROWS($4:4))),"")

Open in new window

2017-12-10b.png
Now I'm wondering how to modify the above formula to allow for a date column in the source list (which may or may not be in order chronologically) and then display the results in a list which is ordered by date as shown here (eg Abigail was listed first in the previous result lists but is now listed last because her associated date is later than the others):

2017-12-10c.png
As shown in the next screenshot, the attached file contains solutions from the two previous threads (AutoFilter 1 and AGGREGATE() 1) and accompanying notes (which are not directly related to the current thread) as well as a new sheet tab, DisplayByDate from which the previous screenshot was taken.

2017-12-10d.png
Thanks

AutoFilter_array-formula-evaluation.xlsm
0
In Microsoft Excel 2013 (and 2010, 2007, 2003, '97) when I closed an XLSM file, it was removed from the Excel VBA Project explorer.

However, in Microsoft Excel 2016, a closed XLSM file remains in the VBA Project explorer.  In fact, even when there is only ONE XLSM file open in Excel, multiple instances of that XLSM file all having the SAME name can appear in the VBA project window!

This can cause serious problems . . . when I'm coding in one instance, when I *think* I'm coding in another.

I have no special Add-Ins.  This problem was introduced solely by upgrading from Excel 2013 to 2016.

How can I remove projects from the VBA Project explorer that are associated with XLSM files that are closed?  Or, better yet, how can I force Excel to automatically remove them from the Project explorer when I close them?

Thank you in advance.
0
Hello fellow Experts Exchange members:

I have a user using Exchange 2010 and Outlook 2016 (the Office 365 version).  The user sends-and-receives a considerable amount of e-mail, and as a result we have been separating the archived mail into separate PST files for each year.

Thus, for example, the user has the following folders in Outlook:
*Username@Company.com
    (the Exchange mailbox)
*Current archive (PST file)
*Archive 2016 (PST file)
*Archive 2015 (PST file)
...
*Archive 2008 (PST file)

(Each of these PST files is upwards of 10 GB in size.)

Recently, when applying the AutoArchive settings through Options - Advanced - AutoArchive window, Outlook has sometimes applied the AutoArchive settings to *ALL OF THE PST FILES* (except the Current Archives PST file).

Each of the PST files has at least a HUNDRED subfolders under the Inbox.  

The problem is that there appears to be no way to bulk-modify the PST file settings to stop Outlook from attempting to archive the contents in old PST files (e.g. Archive 2008) to the Current Archives PST file.

E.g. Outlook will archive not only the contents of the Exchange mailbox but also the old content in the Archive 2008 PST file, Archive 2009 PST file, etc. up to the Archive 2016 PST file and move it to the corresponding folder in the Current Archive PST file.

Have any other Experts Exchange members encountered a situation similar to this?

I would appreciate any advice on how to both bulk-modify Outlook PST…
0
We just purchased action pack and get Dynamics CRM on the cloud using the 5 licenses. I would like to create a test project in visual studio and try to call the web api. Can you show me something how can i do the set up?
For now, all i need is below:

1. create a static method to check the connection is valid or not. return true or false
2. create a static method to read all leads inside of lead entity.  and that is all i need.
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
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

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.