Microsoft Office

59K

Solutions

40K

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

Since moving to Office 365 I have had very sluggish performance in Excel.  I typicall work in workbooks stored in my one drive folder.
Often, when scrolling through cells with the arrow keys the entire workbook will freeze for several seconds.

I noticed in the File Screen, that I do not show a listing for our One Drive Business ....just a personal one which I do not use.  It also shows 'Loading services' that never changes?   See screenshot.

All shows normally in Word and Powerpoint, so this is just an Excel thing.  I have tried uninistalling and reinstalling Office 365 from the portal, but the problem remains.   I have also tried running both repairs from Control Panel - CHange..... still no different.

How can I correct?
stuck_excel.png
0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
1
hi,

how to password protect excel/word/powerpoint file?

thanks.
0
Hi Guys,

i wanted to create a rule in outlook which places any mail received from a distribution list into a specific folder.

the DL is setup on office 365. and when a user sends mail to the DL i want that to then go into a specific folder.

you cant do a rule which states 'Sent to ........' because this only lets you pick users not a DL.

Help
0
I am attaching a file that has two Start entries (C4 and C31). This is just a sample set so this would be repeated for thousands of rows. I want to know how to do two things: how do I count the number of entries between each Start e.g. it should be 26 - but to do that for all the rows in the data set. Secondly how do I show the time elapsed (in hours) between each occurrence of start. (cell T7) - again for each occurrence  of this start...basically the idea is that a pump starts...does its thing. Stops and then starts again...
EE--calculating-rows-between-entrie.xlsx
0
all mails are come spam folder in office 365?
0
Hi There,

I have an excel utility that creates a txt file containing metadata to be loaded into another system.  This has started to fail after the users upgrade to O365 / Excel 2016.

It creates the text file by creating an object referencing itself as a recordset:

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:\Users\Jbloggs\Documents\user\ACTIVE\2017 07 - A&B\03 - Build\ExportFile.xlsm;
Extended Properties="Excel 12.0 Xml;
HDR=No;
IMEX=1";

However when this code is opened I receive the following error:

Code Running
Error...

Error Message

I have tried this on another machine with Excel 2016 and this code works without issue.

Any guidance would be greatly appreciated.

Many Thanks,
Mark
0
Need to have an query for 4 num exact to be show in  NUM sheet ans NUM_VER sheet (first to get done)

then show the 13 set brging location 1

In this file is very importante show

column F location 1 in yellow background (to be audit)

column L

column M

column N
num4all.xlsm
0
A low-severity alert has been triggered
⚠ Malware campaign detected and blocked
Severity: ● Low
Time: 7/24/2017 2:30:00 AM (UTC)
Activity: Protection
User: N/A
Details: 59 message hits on Reputation in 30 minutes.

How do an admin investigate or go about handling this situation, does the admin need to be proactive about such alerts or we could ignore them and resolve these alerts being confident on office 365 Threat protection methodologies.
0
The attached example file contains three identifier columns with the main identifier being a code in column C.
There are duplicate codes at random down column C - Rows 3 & 4,  114 & 115, 185 & 186, and 196 & 197, are examples shown in red.

The objective is to have the contents of the lower duplicate row added to the contents of the cell above and then the lower row to be deleted.
The columns affected are from D to KQ.

The actual files have about 60,000 rows.
Example-file-with-duplicate-ID-code.xlsx
0
Free Tool: IP Lookup
LVL 9
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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 two tabs in the attached file. I am trying to create a "Result sheet" based off my  "Data sheet". I need a standard subtotal for every "Sales Person" in these fields:

1) "Amount Collected"
2) "Amount Put Back"
3) "Amount tendered"
4) "Returns"
5) "Amount"
6) "Amount removed".

But the "Final Amount" field is a different calculation. It needs to be the last "Final Amount" that was greater than 0 for that "Sales Person", BUT if there were any "Amount Put Back" AFTER the date of the last "Final Amount", these need to be added to the "Final Amount". But note that is said AFTER. If these "Amount Put Back" were BEFORE the last "Final Amount" that was greater than 0, they do not need to be added. Individual explanations for each "Final Amount" is in the spreadsheet.
Testing-file-07232017.xlsm
0
need query column I location 1

and show 13 set  coulmns L , M , N
in  sheet  ORD,  ORD_VER
29045921--2-.xlsm
0
need query column G location 7

and show 13 set  coulmns L , M , N
in  sheet  NUM-M  and NUM-M_VER
29045909--1-.xlsm
0
This file is an num 3  

 need look for column F  location 1 set of 13  to show coulmn F  column L column M and column N Data
n3PAL_1.xlsx
0
Hi
I can't move folders or sub folders  in my left hand screen  panel from one folder to another although I can move emails from one folder to another. e.g if i create a sub folder erroneously in one folder I can't move it to the right folder.  I used to be able to do it in previous versions of outlook. I am not sure what the fault is as one should be able to do it by either clicking and moving or using the move box but nothing works. When I move it. it stays there for about a second then jumps back to its previous location however many times I try it

Hope you can help. It is very puzzling.

Regards

Logan
0
I found Helvetica 12 pt to be more readable that Time 12 and used it for me entire book.

I wrote the book in Word (Mac 2017) and exported to PDF.

Is Helvetica typically available on people PC's and devices?

Thanks
0
I have this formula in the cell:

='Loppöversikt och loppanalyser'!C2

And it should have retrieved the date "20170620" from C2 on that tab. But instead, "2E+07" is written in the cell. I've tried to change the formatting in the cell, but nothing is accepted by Excel.
1
if someone has CTC 4.7 L per annum(Delhi, India),
what should be salary breakup per month?
0
I have made T.O.C.'s before and find it simple. But I do not want to use Title 1 to define the Chapter heading.

How do I do set me own?

I want it to be:

Helvetica 16
Bold
Centered

Thanks
0
Free Tool: Site Down Detector
LVL 9
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

The following code helps me convert date values into dd-mmm-yyyy, what I'd like to do in addition is then convert the values into text.

So it would stay as dd-mmm-yyyy but the cell value would be text not a date format. I thought one way maybe to text special, but at the moment I have to paste the values into notepad and then pre format the cells so that they enter as text.

Private Sub CommandButton1_Click()
Dim cell As Range
For Each cell In Selection
cell.NumberFormat = "dd-mmm-yyyy"
Next cell

End Sub

Many thanks for your help.
0
Hi,
I got a question, how to add an additional language pack in terminal server. default is English. but, there is just one user who needs Chinese language. How do I add extra language pack in office, so when that particular user logs to terminal server, he can switch to Chinese from English?

Thank you
0
need look for column F location 1 set of 13  to show column L column M and column N
n3PAL_1.xlsx
0
Hello Experts,

Attached are two files, the MS Access db where I am trying to create multiple records based on the comments fields in the one record. The MS Excel spreadsheet contains a sample of what I am trying to accomplish.

I am able to move the records to a new table, but I am lost on the step where I want to duplicate the record based on how many comments are in the note field.

The attached Excel spreadsheet is a sample of what I am trying to accomplish based on MS Access ID=621.

Can you please help me out?

Thank you,

Steph_M
Sample.accdb
SampleNewRecord.xlsx
0
I have an Excel sheet that I am trying to find and hide rows where cells in column A contain the symbol <.
The problem is that the cell values are defined as one long string, and it is not finding the symbol by it's self.
For instance, in the following data:

1 Random Text
2 Also Random Text
3 <p>Another Random Text Also</p>
4 More Random Text
5<p>Last Random Texts</p>


The code is supposed to resolve this into:

1 Random Text
2 Also Random Text
4 More Random Text


This is what I have so far:
Sub Button1_Click()
Dim N As Long, I As Long, j As Long
N = Cells(Rows.Count, "A").End(xlUp).Row
j = 2
For I = 2 To N
If InStr(1, cell, "<", 1) then
ActiveCell.EntireRow.Select
Selection.EntireRow.Hidden = True
Else
ActiveCell.EntireRow.Select
Selection.EntireRow.Hidden = False
EndIf
Next I
End Sub

Open in new window

0
Dear All,
I am new and hope you might help. I use Windos 10 Home and MS Office / Word 2013.

This is the story.
1) I create a Word document on a USB stick
2) I saved the file onto the USB stick.
3) I edited many times the document at different times and in different days but always working on the USB stick.
4) the file was never saved on the hard drive (always edited on the USB stick)

Question:
1) Is there any viable possibility (eg. forensic investigation) that some trace or info of the document (the one that has always been on the USB stick) have been stored in the PC?
2) Should this have happened, where could said traces have been stored (swap files? tmp files? any other location')
3) Could these traces be retrieved somehow (eg. filename or even the contents of the doc file)?

Regards

WS
0

Microsoft Office

59K

Solutions

40K

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.