Microsoft Excel





Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

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

Sign up to Post

I need a 1 hour online training on Pivot Tables for a group of 6 colleagues, with exercises and demos.


1) Learn how to use Pivot Tables created by others, slice, filter and analyse data
2) Learn how to create Pivot Tables yourself

Please let me know your fees for such a training. Any samples, videos, recommendations that help us understand your strengths as a trainer would be highly appreciated.
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Hi All

Is it possible to use VBA to display the dimensions of a shape object in a cell in real time? For example, if a rectangle shape's width is currently 300 and I select it on the sheet and drag the width to 500, can I display the changing width in a cell?


I'm using Excel 2010 with a data connection to a sql server on my domain. I'd like to share a workbook with other users so they can see refreshed data upon opening. The users don't have a SQL server logon. What are the steps to send a copy of the workbook to other users so they can use it with minimal fuss? Do I need to install an .odc file on the user's desktop?
what I want is copy the data and paste in the same sheet as shown in the sample file  by vba
importing data to a column in an existing spread sheet with pivot table. Most of the data in the cells come over fine but there  are a few cells that display (#VALUE!). If you go to a blank cell in another column, right click and choose 'delete', the affected cell thens shows the correct data instead of #VALUE! . This is ver strange and related only to this computer running Microsoft Office 2013 Pro. The same import works fine on other computers. Thanks
Outlook 2010-this file cannot be previewed because because of an error with the following previewer: microsoft excel previewer

I have a user who has a Windows 7 64-bit OS, running Office 2000 STD 32-bit and Excel 2013 32-bit. The user gets the above error message when trying to preview Excel document in Outlook 2010.

The user is able to preview any other type of attachment in Outlook (.doc, pdf, jpg, etc.) and can preview Excel documents in the Windows Explorer preview pane. so Excel documents can be previewed outside of Outlook 2010.

Steps I have taken so far:
1. Repaired the Excel 2013 install.
2. Checked that preview is turned on for Excel in the Outlook Trust Center-Attachment Handling.
3. Ran dcomcnfg and made sure the Default Authentication Level was 'Connect' and the Default Impersonation Level was 'Identify'
4. I deleted the files located here: %userprofile%\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\
5. I deleted the files located here: %temp%
6. Went to HKLM\software\microsoft\windows\current version\preview handlers in registry to confirm Excel preview handler was there. "{00020827-0000-0000-C000-000000000046}"="Microsoft Excel previewer"
7. I removed and re-added the above.

I probably tried some other stuff that I did not include because I do not remember what they were.

I have 2 other PCs with the same setup but they are able to preview Excel documents from Outlook 2010
I Have Problem with Microsoft Office 2010 Excel i have Enable Security Settings but when i restart computer it automatically disabled

i want macro security options enabled for any time and through some regitory or  hotkey or any other solution.

Please Guide Regards,
Normally, when I open Excel,  the startup automatically opens every workbook that is in  C:\Users\Bob\AppData\Roaming\Microsoft\Excel\XLSTART\

But, I have an "SecondMonitor" macro that launches a second instance of excel by using  Set NewApp = CreateObject("Excel.application")  .

The second instance does not open xlstart files.  In fact, I suspect there are other startup steps are skipped, but that is conjecture.

One way to fix this problem for SecondMonitor to loop through the files using Dir or similar code, and I do not need any help with that code.

But I was wondering if there is a way to tell the second instance to do everything that Excel do if there was a normal startup?

I have an issue going on that has me scratching my head. I have a new computer I built with windows 10 enterprise. I also Installed Office 2016 Profession Plus 64 bit on it. This in in a windows Network environment "probably not relevant, but thought I would mention".

Anyway this is the CEO's computer, and he does a lot of budgeting on Excel. The issue is that excel will just totally lock up randomly. Last week I completely uninstalled it. Before I had extracted the iso file onto a USB using the Win 7 USB tool. This time I just mounted it as a drive "seeing that win 10 has that capability". However it is still doing the same thing as of this morning.

Any thoughts would be appreciated.

Free Tool: Path Explorer
LVL 12
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I have an excel sheet that I have to separate into individual PDFs by department number and then email each PDF to the appropriate supervisor.  We have around 190 crews; so 190 separate emails (which is very time consuming.
Hi - We have an excel spreadsheet located within a shared folder on a Windows server. 3 users will access and update this spreadsheet at various times throughout the day. When one user is accessing the spreadsheet, we would like any other users who try to access the spreadsheet to be told that it's in use and to try again later. We do not want the spreadsheet to be opened in read only mode. Is this possible?
how can I subtract 20d 2h 3m in 1h 10m using a formula

      2h 10m - 1h 10m = 1h
     1d  58m - 1h 10m  = 23h 48m

whats the formula for that ?
Occasionally I will be running a macro and I will receive an error message and then the workbook gets deleted !  How can I troubleshoot why the macro gets deleted ?  I have had this happen with different workbooks all that have macros (VBA).  The common denominator is that they all involve importing data with an ODBC connection.  Unfortunately I do not recall the error message.  It is rare that this happens, but enough that I need to investigate.
What is the shortcut to copy anything from one cell to the next 200 rows in the same column? I use shift + Page down but it takes me a while. Is there a way I can do it just in one click?
i get this problem "side by side configuration error"
Activation context generation failed for "C:\Program Files (x86)\Microsoft Office\root\Office16\lync.exe.Manifest".Error in manifest or policy file "C:\Program Files (x86)\Microsoft Office\root\Office16\UccApi.DLL" on line 1. Component identity found in manifest does not match the identity of the component requested. Reference is UccApi,processorArchitecture="AMD64",type="win32",version="". Definition is UccApi,processorArchitecture="x86",type="win32",version="". Please use sxstrace.exe for detailed diagnosis.
I have 50 visual foxpro files in my computer. I want to transform that contents to excel is that possible??
If it's possible means how to that?
I know that pivot table slicers are a new feature of the Microsoft office 2010.
Is it possible have them created in 2007 as well?
How can I add a function to copy the current range into the next three available rows and then change the date in the last row?
at moment I am able to cpy to the following row and updated the date but I am trying to copy the current row to the next three rows and then only change the last row date.

Sub CreateForecastLines()
Dim DaysToSubtract As Integer 'By Default, sub will prompt to use Thursday's data on Monday (2 working days ago)
Dim frmDates As New frmEnterDates
Application.DisplayAlerts = False
'macro will normally be used to create rows for previous working day, copying rows from 2 working days ago
'DaysToSubtract is an offset to catch weekends
Select Case Weekday(Date)
Case 2
    DaysToSubtract = 3
Case Else
    DaysToSubtract = 1
End Select
frmDates.txCurrentDate = Format(Date - DaysToSubtract, "dd/MM/yyyy")
frmDates.txStartDate = Format(Date - (DaysToSubtract + 1), "dd/MM/yyyy")
If frmDates.frmCancelled = True Then
    Exit Sub
End If
Dim SourceDate, DestDate As Date
SourceDate = CDate(frmDates.txStartDate)
DestDate = CDate(frmDates.txCurrentDate)
Application.StatusBar = "Creating Ac Balances..."
Dim SourceRow, DestRow, RNums() As Integer
Dim WSName As String
WSName = "Ac Balances"
With Worksheets(WSName)
Application.StatusBar = "Creating " & WSName & " Records..."
RNums = Get_Source_Dest_Rows(SourceDate, DestDate)
SourceRow = RNums(0)
DestRow = RNums(1)

    'Check Source Row and DestRow have been found

Open in new window

Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Probably something that anyone who uses Excel has asked. When I open an Excel file (double-clicking on the file) how can it be made to open in its own window?


When I open the file after doing this it opens a new window but I get the message: "THERE WAS A PROBLEM SENDING THE COMMAND TO THE PROGRAM" and the file doesn't open.

Google says the solution to the latter problem is to undo the former change.

At the moment the workaround (because it feels like more steps than should be necessary) is to open a new Excel window manually and drag the desired file in to be opened or opened via the file menu etc. I am sure I have got this working in the past but do not recall the trick to it. I have also seen all the reg hacks and stuff but I am sceptical about it being so complicated.

Excel 2010 (64 bit) on Windows 7 (64 bit). All software is patched and up to date. Please help.
I had this question after viewing excel - time conversion ( IST to EST ).

Please provide the formula to convert IST 12:09:50 AM to UTC
I tried entering the formula =A1-time(5,30,00)
But this is throwing error.
I want to randomly distribute a Range of given Elements .
I have attached a sheet please see that.

I want fruits to be distributed randomly to the student .
The next day distribution should be such that the student doesnot get the same fruit (And all the fruits in the range should be used)
i.e. it should check whether same fruit is allotted or not .,If yes , then RAndom distribution again untill fruit doesnt matches .

*Need vba code for it
How do I change my settings, so that when I want to open a previous excel spreadsheet, the  tabs show 1 instead of y1?
Is it possible to filter cells by VBA code?
In one sheet all the tables with filters will be there and in next sheet we have to create one user form window.

In user form window we have to give all the details and if we submit that sheet it should go to first page displays only that data. It has also display the pie chart for the same.

Please help someone....
Hi Team,

Again sorry for too many questions. Just trying to understand the way for many manual task that is making my life as nightmare.

The requirement is  - I have a 100+excel and word files, where I have search for particular text say "Reviewer" and get the master list which contains the below output -

File name - Reviewer text (Yes/No)..

Again the files are combination of word and excel. where on every documents, we have to update the reviewer name . So i need check if it is updated or not. Checking manually on each file using Find and replace is taking lot time.So, just wanted to see if this can be run on folder wise and get the details in one shot

Microsoft Excel





Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.