Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

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

Hi,

I need to sum some 30+ products like in the image below.
Basically look for the code in the lookup table, take the value, multiply it with the number in the next column. Then take all results and get the sum.
I can do it the long way, but the result is going to be a very long formula that's hard to maintain.

How can I do it with a shorter formula?
Thank you.

2017-09-22-09_39_44-2017.09.xlsx---E.png
0
Get your Disaster Recovery as a Service basics
LVL 1
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Normally, you write a negative value with a minus sign with no blank space between, like this:

-48.8

But in my Excel sheet, this is written like this:

- 48.8

How can I change this so it's always written like -48.8 (without the blank space)?
0
Hi all,
We are going to deploy Office 2016 (Currently using Office 2010) through SCCM 2012, what do we have to take into account before update process?
Also how does SCCM uninstalls the old office and installs the new one on the top? how does it differentiates between office32 bit and 64? and then install the right version?
Any articles and steps on how to deploy and configure it will be helpful.
Would installing office 2016 through SCCM would be the best way? or deploying it through Group policy will be better?

Thanks.
0
I have a pick list of months  (January 2017, February 2017, March 2017)  and a corresponding table by month.  
Depending on what month I choose I want the data for that month to show up under the month that i have chosen.
( I can get it for January but not sure how to add if I pick a different month)
(see attached)

thanks so much
Kelly
1A.xlsx
0
Can anyone help me to provide steps to generate diskspace report from SCOM 2012 R2? Thanks
0
Hi-

I want to Delete Word Bookmarked Text and paragraph Data using OpenXML in .Net.

I have below code using OpenXML and "Content controls". But my plan is to do the same using "Bookmarks".
I haven't found OpenXML solution to edit and delete text and paragraphs using bookmarks.

using (WordprocessingDocument myDoc = WordprocessingDocument.Open(destFilename, true))
            {
                MainDocumentPart mainPart = myDoc.MainDocumentPart;
                DocumentFormat.OpenXml.Wordprocessing.Document bodyDoc = mainPart.Document;
                IEnumerable<SdtBlock> ccBlocks = bodyDoc.Descendants<SdtBlock>();
                IEnumerable<SdtRun> ccRuns = bodyDoc.Descendants<SdtRun>();

                foreach (var item in cBO.map)
                {
                    
                    SdtBlock myBlock = ccBlocks.FirstOrDefault(ccb => ccb.Descendants<SdtAlias>().FirstOrDefault().Val == item.Key);
                    SdtRun myRun = ccRuns.FirstOrDefault(ccb => ccb.Descendants<SdtAlias>().FirstOrDefault().Val == item.Key);
                  
                    Text textContent=new Text();
                    if (myBlock != null)
                    {
                        textContent = myBlock.Descendants<Text>().FirstOrDefault();
                    }
                    if(myRun != null)
                    {
                        textContent = myRun.Descendants<Text>().FirstOrDefault();
                    }
                
                    if

Open in new window

0
I am trying to sum up a total of minutes, divide it by 60, and get an actual HOURS:MINUTES result.

I have a total of 315 minutes. Divided that by 60 and the result is 5.25. The .25 is a quart of an hour and I need to get the actual 15 minutes. Does that make sense?

So a total of 315 is actually 5 hours and 15 minutes. That is the result I'm trying to come up with, not .25 as a quarter of an hour.

C'mon, time formula's are fun!
Thanks folks!
Ken
0
I was looking for assistance in customizing the Software compliance - 1 and 3 reports.  I do not want it to prompt for collection ID or software update group.  I want to specify in the report the collection ID and Software update group so i can save each one individually and set up subscriptions to have them emailed to the site leads for each location(collection) every month.
0
We've had intermittent App-V publishing problems for a few weeks now, where if the client kicks off an App-V publishing refresh within the first 30 or so minutes after login, the publishing refresh would fail (even when manually running Sync-AppvPublishingServer from PowerShell), and then none of the apps launch.  After around 30 mins on an user session, the problem magically sorts itself out.

After much troubleshooting, it's become apparent that the problem seems to be due to the fact that the client is asking our local proxy server to find the publishing server (which is at http://ctxapp-v01.domain.local:82).  Now, for a start, the proxy server will block any attempts at port 82, so it gives a 403 error.  But that's not the point, the point is that it shouldn't even be trying to get to this via the proxy server at all, because I have the "bypass proxy server for local addresses" box ticked.  I've tried disabling the IE proxy altogether in Internet Options before kicking off the Sync-AppvPublishingServer command, but to no avail.  I've also tried to enable it, but explicitly add the App-V server address into the proxy exceptions list.  I've even tried setting the local system proxy to None using the command 'netsh winhttp reset proxy', but still no joy with anything.

I can ping/browse to the App-V server from the client machine no problem - it's even inside the same subnet.

Is there a hard-wired way to tell the App-V client to never try to go through the proxy …
0
What steps need to be followed so that I can make the far left hand Outlook 2016 column larger (so that the People icon at the bottom of the column) will also display (see the screenshot).

Currently when I drag this column to make it larger it always reverts back to this smaller size.

How can I make this column permanently retain the larger size?

Left Outlook pane
0
Survive A High-Traffic Event with Percona
LVL 3
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Hi,

I just inherited a new client and put in  shadow copies and proper backups 9/8/17.

They have a XLXS document that was last modified on 8/23/17 and they are trying to access it today. However they get an error "Excel cannot open file 'file.xlsx' because file format or extension is not valid". This is happening on all the computers not just 1

I can not restore this file from backups because I just put them in and my shadow copies do not go back that far.

I have tried:
1. Renaming the file to xls - it does not work it just opens a blank excel doc
2. Repairing the document in excel- Does not work
3. Adding the network location to the trusted trust center
4. Copying it to a local C drive - Does not work, same error
5. Disabling hardware graphics acceleration
6. Making sure the xlsx is associated to excel in default programs
7. Checked Ignore other applications that use Dynamic Data (DDE)

I feel like I fixed this before with a reg key.

Can someone please help. This is a very important document for my client. If there is a software that will fix it I am open to purchasing.
0
Hi,

I have an excel document that has number rows and columns and it is presented in a standardized format. Each cell has a very specific formula and tends to be either hard coded and wrong or missed and wrong.

I am curious if it possible to prevent users from adding and removing rows and columns and then add a dropdown button to add rows and another button to add columns

Each of these buttons would be placed at the end of a range.

Hopefully, these buttons would, when click, copy the formulas from the columns/rows within the set range and append a row/column at the end of the range
0
Hi

I am looking for  a VB script that would search full name or user name in the Excel spreadsheet.
It would be great if I could type user name or full name in the search box and scan against Excel Spreadsheet
The output should be exported to csv file and display on the page.

Can you please help me?

Thx, M
Test-groupname.xlsx
0
Good Afternoon

You will see on this sheet that I have a 'Statistics - Made' table which shows 'Pure Bristle', 'Mixed Bristle' and 'Nylon'.

Rather than me spend time each month recreating the formulas for each month, I would like the table to automatically populate with the relevant numbers for that month.

- Pure Bristle = B1, SB1, B2, SB2, B3, SB3, B4, CB4, EB4 and SB4
- Bristle & Nylon = BN1, BN2, BN3 and BN4
- Nylon = N1, NU2, NG2, N3, N3 and N4

I would be grateful of someone's assistance on this matter.

Best Wishes
0
I want to process multiple files from the folder.

This is code.
$file = 'C:\temp\RP\test'
$xlApp = New-Object -Com Excel.Application
$xlApp.Visible = $false
$wb = $xlApp.Workbooks.Open($file + '.xlsx')
$filedest='C:\Temp\'
foreach ($ws in $wb.Worksheets)
{
  $ws.SaveAs($filedest + '_' + $ws.Name, [Microsoft.Office.Interop.Excel.xlFileFormat]::xlExcel12)
  break
}
$wb.Close(0)
$xlApp.Quit()

I tried using below  but  failed.
$file = Get-ChildItem "C:\temp\RP\" -Filter *.xlsx .

Could any one please hemp in this ?
0
HI,

A client has sent us an excel spreadsheet that references "sheet 3" in some formulas but the sheet is not listed along the bottom with the other sheets and if you right click any of the other 9 sheets the unhide option is greyed out.

Is there any other way to get access to this hidden sheet?
Thanks
0
Hello,

How much of a performance difference is there between Excel (2010) 32-bit vs Excel 64-bit when working with large files?

I occasionally work with large (200+ MB) .xlsm files which contain mostly text. When doing so it's not uncommon to experience sluggishness and/or get a pop-up saying Excel needs more resources. Also, I've noticed the Task Manager showing Excel to be using well over 1,000 MB of memory during those occurrences.

On the website listing Microsoft Excel specifications and limits, I found the following statement regarding memory usage for 32 vs 64-bit versions:

Maximum limits of memory storage and file size for Data Model workbooks

32-bit environment is subject to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process. A data model’s share of the address space might run up to 500 – 700 megabytes (MB), but could be less if other data models and add-ins are loaded.

64-bit environment imposes no hard limits on file size. Workbook size is limited only by available memory and system resources.

So with a fairly fast processor and 16 GB of memory, could I anticipate a significant improvement in performance and responsiveness?

Thanks
0
Dear all;

I have migrated our email to cloud base 365 and we have problem that Microsoft office 365 always update its package most of the week it make our internet speed slow down as our user keep update it with microsoft connection. So is there anyways to create a local server for point microsoft office update its package?

Really appreciate for your help.
Thanks
0
I had this question after viewing setting the focus to a form control in ms/access.

On my app, after inputting a value on a form, I need the form to be closed and have the control back to the form that originally invoked it. How do I do it? Closing the form does not work - ms/access refuses to do so...
0
How to Use the Help Bell
LVL 10
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Could you in office 365 /outlook restrict email or meeting invites forwarding
0
I had a product, dos based, that was capable of extracting data from a large mass of comma delimited data. It worked fine up to Win 7. I think later versions of Windows, 8, 8.1 and 10 may have changed the dos version, or the structure of Windows itself changed. At any rate, trying to run the product now generates an error message telling me to consult the manufacturer. Alas, the author of this utility is nowhere to be found; I've looked. The program/utility was named InfoTransFOR. If someone could suggest ways of running it, it is a bit convoluted or has another suggestion to solve the problem, I'd be happy to award points for a solution. I may try to run it in a virtual machine with an older operating system, but that would complicate an already complicated process. Can anyone help?
0
I have to write a code that integrates visual C# with an active lotus notes server and searches for attachments in the inbox given a specific string in the subject line, these attachments need to be stored in a specific server location.

I am new to C# hence would appreciate any help from anybody who has done something similar
0
I am trying to create a quick way to automate a very time-consuming task. The issue is that the data will have multiple duplicate order numbers in one column, but are at different sequences within the operations within the plant. I only need to delete the rows that have both duplicate order and sequence numbers. Any idea for a VBA script that could help with this issue?
0
Hi,

i tried the below script to download all the attachment of incoming mails to my outlook automatically using "run a script" option. I wrote the script in vb editor for outlook and added a rule as well. But it is not downloading any attachments to the folder I specified in my script. Please help me analyze the issue.


script

Public Sub SaveAttachmentsToDisk(MItem As Outlook.MailItem)
Dim oAttachment As Outlook.Attachment
Dim sSaveFolder As String
sSaveFolder = "<path-to-save-the-files>"
For Each oAttachment In MItem.Attachments
oAttachment.SaveAsFile sSaveFolder & oAttachment.DisplayName
Next
End Sub

Thanks
Bharath
0
Hi All,
We are planning to create a new forest for Exchange migration 2007 - 2016, reason for creating new forest is because less risk, downtime and can prepare new exchange server / environment, we have 5 different regions, we all are currently in one domain one forest, we are planning to utilize priasoft software (https://www.priasoft.com/using-a-dedicated-exchange-forest-resource-forest/), that's so far the best tool we have found for migration, any other tool suggestions for migration?

Need assistance in creating new forest for Exchange migration, means steps and articles which applies to scenario which I listed above.

thanks.
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.