Microsoft Office

69K

Solutions

42K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

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

Sign up to Post

I have to replace the exchange  certificate. We are in a hybrid environment with O365 with all mailboxes in O365. Mail still flows through internal servers.
I plan to use the following method:-
- Copy the pfx file to the server.
- Open EAC and Import new pfx file
- Move the services to the new cert

Do we need to do something on Office 365 side as well?
And any other step to think of?
And if ADFS is used for Office 365 then are there more steps to follow?
0
I have to replace the ADFS certificate on the server. How can I determine all the servers involved in ADFS.
I plan to use the following method:-
1. Import the new certificate into the server certificate store.
2. From the ADFS management console set services communications certificate and select the new certificate. Do the same for token signing. Restart ADFS service.
3. Run following command with the thumbprint of new cert:
Set-AdfsSslCertificate –Thumbprint xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
4. On the ADFS WAP server run following commands for the new cert thumbprint:-
Set-WebApplicationProxySslCertificate –Thumbprint xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Set-WebApplicationProxyApplication –ExternalCertificateThumbprint xxxxxxxxxxxxxxxxxxxxxxxxxx

Do we need to do something from the vendor side who use ADFS for sso?
And any other step to think of?
And if ADFS is used for Office 365 then are there more steps to follow?
0
A bug in the attached script creates all blank output when the cell references have not data.

For example, cell BR10 is blank, so the "Numbers_3" sheet has not data. It has to do with blank cells, because when I put data in that cells I get cell data in "Numbers_3" sheet.

I would like to resolve it where I can have blank cells because if I have to put data beyond number 70 I will need another script that will delete any row containing any number above 70.


blank cells create blank resultsGreen represents blank cells

The attached file contains data in all the "Numbers_X" sheets but after the macro is run only Numbers_2 has data and it is the only filled line.
CreateCombinationsBug_sheetsblank-c.xlsb
0
I have a hybrid setup with Office 365 and the Exchange Server 2016 onsite for management purposes only. I lost my Exchange server, and need to reinstall it on a VM. Does anyone have a friendly guide on how to do this?
0
Hello All, I am in need of help to find a solution to create an excel list containing a 2016 SharePoint Site Collection, including the top-level sites, sub-sites, and list/libraries under those sites. If able to get down to file level to include in list as well.  Would like to have the name of item, the path and modified date, modified by information.   I have Office 2013 currently.

I have searched and asked others for help but so far have not found a viable solution.  

This is my first post.

Thanks,
Steve
0
I have an Excel file that runs a sort macro that was generated by the Excel macro recorder (see photo below). I have given this file to a couple of others to test. One of them is getting an error when this code runs. I am not getting the error and neither is one of the other people. I am running Excel 2019 and the one getting the error is running 2016. Not sure which version the other one who is not getting the error is running. Again, this code was generated by the macro recorder. Can anyone please help me understand why this is occurring for just one out of three people?

Thanks,

Error in code
Excel error message
0
We have an office with everyone running office 365.  The office still has an exchange server.  We use office 365 only for the office products We're having an issue with everyones outlook freezing at different times throughout the day. I have tried running outlook in safe mode as a test, and when I put it in safe mode the issue goes away. Otherwise it locks up from time to time anywhere  from 13 seconds to 30 seconds and can't figure out why. Anyone else have this issue?
0
Hi Experts,
 We have one Source file in particular folder. We also have Report file where we use source tab for reporting. Our requirement to use latest source file in Report workbook. I need your help for macro to read latest file from (C:/Source) folder and Delete all data from Report workbook and copy latest data from Source file and paste to Report tab.

So our requirement to delete old data from sheet and update it from Source folder so we can eliminate manually copy paste.

Source File
Source-File.xlsx

Output Workbook
Report.xlsm
0
I have a client that currently has SBS2011 with Exchange 2010 in-house.   I am recommending upgrading to Server 2019 Essentials and moving their e-mail to Office 365.

This client is very concerned (paranoid) that the data in their e-mail could be compromised or hacked, even by Microsoft personnel, since they communicate sensitive information with their clients and their lawyers.

I had talked to them previously about files stored in the “cloud” and how they sometimes are secured with a private encryption key so that even the personnel at the “host” couldn’t access the data; Azure Backup Encryption Passphrase for example.

How secure is the Exchange data that is stored on Microsoft’s servers (Office 365), and how is it secured?

Thank you in advance for any assistance and advice.
0
I have a weird problem. 4 users access the same file on a shared drive, only 2 of the 4 have the MACRO listed under Macros in the same file. How can I find where this macro is located.
0
I had this question after viewing Random hours in timesheet.

As a complete newbie to VBA I followed the exact instructions provided in the quoted post. My problem is really really similar with a view exceptions. I need to work with Integers only and without specific percentages, rather Total hours per project as input values, which suppose to be randomly distributed across workdays respecting total hrs per day allowed by the employer on a specific day (example attached). So the bottom row is a manual input as well.
Timesheet Example
I started first to make the already proposed solution running. I made the following changes to the original script (disclaimer: working on Mac):
  • deleted all CDec() comands and replaced with simple natural numbers, since I need Integers only
  • replaced Scripting.Dictionary with another one since in VBA 2019 on Mac there is no "Microsoft Scripting Runtime". (Found a replacement also online that seems to work)

But having two issues:
While compiling a VBA Project there seem to be no mistakes or anything. But upon runtime in a single cell it says "Object doesn't support this property or method"
But in general I am assuming I am missing some ground knowledge. How do I run this macro across my cells? How do I provide input. What if I need to add 5 or 8 customers. Where do I input target hours per customer. Or how can I expand it to a whole month. So where is the input and output if I may say it like this.

Thanks in advance for any help.
0
We have some users that would like to use Windows Hello features that continue to be greyed out or state "Something Went Wrong. Try again later".  Our domain is using Azure AD connect mainly for the purposes of Hybrid Exchange with Office 365 and I'm wondering if there is more to do on the cloud end or if I'm just missing something on the on premises network.  

The policies that are in place are:

Computer configuration\Policies\Administrative Templates
 System\Logon -- Turn on Convenience PIN sign in enabled
Windows Components\Windows Hello for Business
          -----Do not use the following hardware security device TPM1.2 disabled
         ----Use biometrics enabled
         ----use certificate for on-premises authentication enabled
         Use Windows Hello for business\do not start windows hello provisioning after sign-in disabled
   
Biometrics -- Allow domain users to log on using biometrics enabled
                 ---- Allow the use of biometrics Enabled
                   ------Allow users to log on using biometrics enabled
Biometrics\Facial Features - Configure enhanced anti-spoofing disabled

User configuration
  Windows settings\security settings\public key policies\certificate services client-auto-enrollment settings
 --- Automatic certificate management enabled
          Options- Enroll new certificates, renew expired certificates, process pending certificate requests and remove revoked certificates enabled
                         -- …
0
Office 365.  What is the best way to help out the problem of too many emails ending up in quarantine that should not be flagged as spam?  It is becoming a bit of a problem.  Can I tweak anything to make it less strict?
0
Can someone provide help in filtering data in Spotfire please?
0
I have 2  excel columns which are not sorted and I would like to compare what is in Column A not in Column B. I'd like to place that value in Column C.
I also like to find out what is in Col B not in Col A and placed that value in Column D.
0
The attached file contains a similar formula in cells Q21:Z27. the formula in Q21 is below. The formulas return numbers within a range.


=IFERROR(AGGREGATE(15,6,OFFSET($C$1:$G$1,1,0,46)/(OFFSET($C$1:$G$1,1,0,46)>P15),1),"")

I am looking for a way to use cell references instead. For instance, value in cell Q19 should replace G1 reference in formula and R19 should replace the second cell reference in the formula. Thus, when either value is changed the references within the formula are changed accordingly.

The Formulas in Q4:Z10 will serve as the original formula and should not be changed. Using a different formula that will have the same results is acceptable as long as the formula is not altered by the addition of rows above it or when it is copied and pasted.
ReturnValuesWithinRange.xlsb
0
Hi there,

We seem to be having an odd issue which has become more prevalent in recent weeks whereby our PA Team, who use a shared resource calendar, input entries, invite attendees etc. however the meeting will skew in the shared calendar to another point in time either months before or ahead of the actual meeting entry. The calendar entry stays correct in the attendee calendar.

When I search for the meeting entry, I can find it at another date - the meeting format is as inputted as well as the time however, it gets inputted to a half hour slot rather than the allotted time of the actual meeting e.g. an hour if that is what it is set to. The date is whatever the entry has gotten skewed to. The image attached shows a bunch of meetings which got moved from the dates they were scheduled for to a particular day in half hour blocks - The times are actually on the meeting but all sitting in at another time.

Exchange-skew.png
We've raised this as a ticket with Microsoft but they aren't coming back with anything fruitful. We've recreated the diary, migrated to Exchange 2016 from 2010 (where the issue was occurring also just not as prominent), removed and re-added the diary delegates, upgraded MS office versions etc. but nothing is working.

Any ideas anyone?

Thanks in advance.
0
We have exchange 2016 and users are unable to set out of office using outlook they can however use webmail and it works no problem at all. Exchange is 2016 single server and client outlook is 2013 and 2016 any help will be appreciated.
0
Office 365 account for Office desktop software (No Office e-mail account) and using only a G-mail hosted domain e-mail.  Due to business e-mail cannot set calendar sharing (iCal) to public other than Free/Busy.  So this is not an option.  One user has 2 physical computers, and needs to get this working.
0
Hello all,

I am importing data from another sheet, but I need to filter so that only the last 60 days of data appear.

First, I have this formula:
=ARRAYFORMULA(QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/[sheet URL]","Form Responses 1!A:K"),"select Col1, Col10, Col11 where Col1 > date '2019-12-21'"))

How do I change this formula to display only the last 60 days, rather than using a hard coded date?
I tried and failed to replace the hard coded date with variations of date() and - 60.

 

Thank you
0
I have a column with 100,00 records. Sometimes when placing a filter and sorting it runs long and times out. Does creating a table for that column help in process time? Another words it wont take as long to filter etc in table format as opposed to a plain column filter? Maybe the processing speed between a table and regular column doesnt matter? Thanks
0
On our process controller servers we have come across an interesting issue since the server was upgraded to server 2019.  An IIS based web app on the host is instructed to upload a file from the user's local disk, then open it in Excel on the host where it will be parsed into a waiting database.  The same code is working well on several other machines that are running server 2008.  On the 2019 host the file uploads, and successfully writes it to the temp directory. Excel is invoked, but it fails to find the file and open it.  A rather generic windows type error is passed back to the app.
"An unexpected error occurred: Microsoft Excel cannot access the file 'C:\Temp\Test SP_WCETest1_001_Test Meter_20200218040939.AMD.xlsx'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook."
I have verified the permissions on the file and the folder are open to group 'everyone' with full control.  From the host console the file will open in excel with a double-click. There are no errors in the event logs beyond the one passed back to IIS. (above)
I pulled up procmon on a working host and compared file activity to the temp directory between the working and non-working.  csv files are attached. Ike is the working 2008 server, Phillip is the failing 2019 server.  The only thing that I found of interest is on Phillip, there is some svchost …
0
Office 2007 on Windows 10 Pro 64 bit.

-Random Word docs the user creates and saves on the network drive loses the owner and he can no longer access the document, sometimes AS he is working on it. It won't even let him close it.
-Other Word docs he creates are fine.
-I have to log into the file server, take ownership of the file, then add the user manually to the security tab. Once I add the user and apply, all the other inheritable permissions populate and the user is able to access.
-PC was updated to Win 10 from Win 7 in the fall.

File Server is Windows Server 2012 R2.
0
When opening Office attachments in Outlook 2016 (32-bit and 64-bit), we receive the prompt "You should only open attachments from a trustworthy source..."   I wanted to know if this prompt can also be set up so that when we receive PDFs and emails, we get the SAME prompt?

Please let me know.  Thanks.
0
Using PowerShell I am looking to copy a column from Excel to a text file. I've scoured everywhere and cannot find what I need to help.
0

Microsoft Office

69K

Solutions

42K

Contributors

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.