Over 1 million tech questions and answers.

COUNTIFS working in Excel 2013 but not in Excel 2010

Q: COUNTIFS working in Excel 2013 but not in Excel 2010


I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!

Preferred Solution: COUNTIFS working in Excel 2013 but not in Excel 2010

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"

Read other 1 answers

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8.

The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is http://www.systematics-int.co.uk/, which has a login page.

What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.

I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.

If you need more info please ask, I don't think I've been clear enough as English is my second language.

A:Excel 2010 web query is not working as it did in Excel 2007

Could ik be that the symantec site has attached your login to a specic Ip address or machine name which now is changed because of your new system?
I don't really think it;s Office 2010.
Your system is new, another mac address, probably a new IP address, new computername.

All these seeminly irrelevant factors may be the reason it's now working, have you tried executing your macro step by step? Trubleshooting takes a lot of patience and time.

I hope this gives you some ideas to look at

Read other 2 answers

I just installed Windows 10 on everyone's laptop here and now I have a bunch of users that their Excel will ocassionally not save or will have graphics issues.  I have tried several suggestions, such as checking their .com add-ins, updating their DisplayLink, and trying to use it in safe mode.  Nothing has been able to fully fix it.  Has anyone else experienced this?  I have heard that Microsoft knows about the issue but has no fixes for it, but I have heard/read that so much that I just don't want to fully believe it.  If anyone has seen this and found a fix can you please help?  Thanks in advance!

Read other answers

Hi All,

So recently I've been having trouble with numerous Excel Spreadsheets on Excel 2013/2010

Issues have included excel freezing, taking a long time to open multiple (large) spreadsheets, copying and pasting taking 3 minutes or more.

Just to give some background; let me start by stating that the excel sheets in question are large in size with lots of links to external sources. I would also add that these spreadsheets where originally created on 2010 rather than 2013. My computer is also running on a corporate network for which i'am an admin.

However, the spec of the machine i'am using, in my opinion, should be more than capable of running these large sheets:

HP Z240
Xeon CPU 3.30GHz
Win 7 Pro

To remedy these problems i have tried numerous troubleshooting including:
Increasing the RAM to 32GB
Turning off protected view via GP
Installing Excel 2010 alongside 2013
Installing 2010 x32
Ensuring all macro's are enabled via GP
Rebuilding the box entirely (software)

None of these have resolved the issues.

I've now found that i have exhausted my knowledge on this issue and so, I'am reaching out to see if any one has any suggestions with how to fix this.

Any help anyone can provide is greatly appreciated!

Read other answers

how to email a excel sheet or excel workbook direct from excel ?tell me the steps.. all of excel 2007,2010,2013.

A:help about excel 2007,2010,2013 all.

Send as an Attachment>

will send the work book , which will use your default email client on the PC

Read other 2 answers

I need to count the number of cells using multiple criterias. the main problem is that in one column in some cells there are names of subsectors (like real estate, property, housing) that i want to count as one sector (real estate). in this case i want to somehow apply an or condition because some cells include more than 1 subsector name hence counting the same cell twice. at the moment i am trying the =SUM(COUNTIFS($U$82:$U$86,">"&1,$Q$82:$Q$86,{"*real*","*house*"})) formula

A:Excel countifs

can we have a sample of dummy data
also what version of excel

Read other 2 answers

Here is part of my code where it errors out in 2013 for the sort .apply but not 2010 and can't figure out why. Help appreciated. I have recorded same in 2013 with same results.

Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Temp Data\mydata.csv"
Selection.Delete Shift:=xlUp
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="<>"
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="="
Application.CutCopyMode = False
Sheets.Add After:=Sheets(Sheets.Count)
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Add Key:=Range( _
"Q:Q"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
With ActiveWorkbook.Worksheets("Sheet2").Sort
.SetRange Range("A:AM")
.Header = xlYes
.MatchCase = F... Read more

A:Solved: Excel 2013 Sort Macro errors out at .Apply but not in 2010

Read other 13 answers

I have been going around in circles trying to crack this one.

I have 2 fields, the first one with company names and the other dates.
Col A Col B
ABC 5 Apr 08
XYZ 11 Jun 08
ABC 3 Jul 08
PQR 13 Feb 08
XYZ 20 Apr 08

What is need is a summary count by month for each company, so
Month Count
Apr 1
May 0
Jun 0
Jul 1

I have managed to count the number of months appearing ( Apr =2) so that I get a summary table, but getting excel to count only if company in Col A is "ABC" is getting to be a frustrating task.

So far i have tried nesting if & countifs as well as sumifs but of no avail

This count function gives the overall number by month

But this nesting is not working

And pointers on how I can do this?

Many thanks...

A:Excel Help - Countifs problem

Read other 7 answers

I am trying to create a formula in Column C that will give me a total result using 2 pieces of information in Column A and one piece of information in Column B.
As the spreadsheet I am using contains confidential clinic information I will give you an example of what I am trying to achieve.
I have a spreadsheet containing the list of names of Doctors in Column A.
In Column B I have a list of different Clinics that they run.
I need to know how many times Dr Black and Dr Brown were at the Bellevue Clinic.
I can use the formula COUNTIFS(A2:A29, "Dr Brown", B2:B29, "Bellevue") to get the required result for one doctor, but can't get it for two. I have tried typing in the formula COUNTIFS(A2:A29, "Dr Brown", A2:A29, "Dr Black", B2:B29, "Bellevue") but the result comes back as zero. Can you help please? I presume I need an OR criteria in the formula, but it won't let me do this.

A:Solved: Excel - COUNTIFS to include OR

Read other 6 answers


I am having trouble returning accurate data in my EXCEL table using COUNTIFS.

My source data is in a separate worksheet within my workbook.

I am trying to determine the number of records that definitely meets at least one criteria, and could meet one or both of two other critieria.

THe data involves providing statistical information for EEO compliance as to how many minorities work in different divisions of the business. The three criteria I'm using are: Department ID, Ethnicity, and Race.

I can easily get the correct return if I'm just looking for how many people in Department ABC are non-white. What I can't get is how many people in Department ABC are either non-white OR hispanic/latino.

=COUNTIFS('Employee Data'!$I$2:$I$998,"<>White",'Employee Data'!$J$2:$J$998,"Group 5: Asst. Mgrs & Technicians/1st Line")

This formula accurately tells me how many people in Group 5 are not white. When I try to roll in a criteria for whether a record also or alternatively includes "hispanic/latino", it double counts an individual if they are hispanic/latino AND non-white. I want to only count them once.

A:Multi-conditional COUNTIFS in Excel

have a look here for multiple criteria
Normally, the SUM function will add all numeric cells in a specified range. However, when used as an array formula with criteria used, it will give us a count instead of a sum.Click to expand...

Read other 2 answers

Is there a way to count a cell if the value is between two numbers. I want it to count cells with values between -0.50 and +0.50. I've tried both of the formulas below and get a result of 0 (I know that's wrong).




A:Solved: Excel countifs problem

Read other 6 answers

I'm working with a large database and trying to write a countifs function. Each part of the function works independently and some of them work together, but when I try to add them all together, I get a #value error. I've given each column in my database a range name to make copying functions easier.

This function works and gives a correct answer:

This function works and gives a correct answer:

This function gives me a #value error


A:Solved: Excel 2007 problem with countifs function

Read other 6 answers

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.

A:Solved: Excel search does not work Excel 2013

Read other 7 answers

I have a userform that after update on Textbox1 code, checks if less than 8 characters and returns msgbox, clears textbox1 and I need it to go back to textbox 1 but continues on to textbox2 no matter what. Any help is appreciated.

Private Sub TextBox1_AfterUpdate()
Dim strResponse1 As String
Dim MasterList As Range, ListEnd As Long
ListEnd = Sheets("Master").Range("A2").End(xlDown).Row
Set MasterList1 = Sheets("Master").Range("A2:A" & ListEnd)
Set MasterList2 = Sheets("Master").Range("A2:F" & ListEnd)
strResponse1 = Left(Me.TextBox1.Value, 8)
If Len(strResponse1) > 7 Then
If Not IsError(Application.Match(strResponse1, MasterList1, 0)) Then
Loc1Lat1 = Application.WorksheetFunction.VLookup(strResponse1, MasterList2, 5, False)
Loc1Long1 = Application.WorksheetFunction.VLookup(strResponse1, MasterList2, 6, False)
MsgBox "Loc1 is in list: $ " & Loc1Lat1
MsgBox "Loc1 is in list: $ " & Loc1Long1
MsgBox "Loc1 is not in list: $ " & Loc1
End If
MsgBox "Value must be greater than 7"
TextBox1.Value = ""
Cancel = True
End If

A:Excel 2013 VBA Setfocus not working on userform after error

Hi Maria,
I think a file with the userform and the code with non-private data will make it easier to help.

Read other 1 answers

I am running Microsoft Office Professional Plus 2010 on Windows 7.

When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:
In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

Thank you in advance fo... Read more

A:PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

Read other 6 answers

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

A:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Read other 16 answers

Hi guys,

Since a day or two I?m having the following issue when I close an excel file (extension xlam).

I write my own addin files and have been using them for many, many years.

I?ve read that this seems to be a bug with Excel 2010 but the strange thing is why now and not before?

The addin is not installed, I run it when I need it, it contains the necessary xlm code with custom ribbons and all the necessary buttons, you name it, it just works as it should.

I have one button that either close the addin or quits Excel altogether

The VBA project?s properties are set to non-visible and password protected.

Now I get the dialog prompt to enter the VBE password. If I enter the password or press cancel, all I get is that Excel has encountered a problem and will shutdown.

OS: Windows 10 64-bit, Office 2010 and everything has been running fine with Windows 01 and before that with Windows 7

VBA Editor window is not maximized (as I read on several posts), and when I remove the password and save it and then reopen the vbe editor does not show up anymore when closing.

If I run the same macro directly, not using the menu button, the same thing happens. It seems like it?s trying to access the VBA properties, but I have not added any code to do that.

Very strange and especially I do not like thing I do not understand, no changes made and I do not address the VBE components in any way.

Any ideas?
P.S. I cannot upload the file but the thing is that it just started, all at on... Read more

Read other answers

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

A:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

Read other 1 answers

I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):

(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.

I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.

Nothing has worked. Iím barely able to get anything done! Please help, Iím dying here!

A:Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

Read other 16 answers


Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:



We're used to Office 2003, so this is a big jump at work for us



A:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.

Read other 1 answers

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A6-4400M APU with Radeon(tm) HD Graphics, AMD64 Family 21 Model 16 Stepping 1
Processor Count: 2
RAM: 7650 Mb
Graphics Card: AMD Radeon HD 7670M, -2048 Mb
Hard Drives: C: Total - 931724 MB, Free - 865841 MB; D: Total - 21840 MB, Free - 2343 MB;
Motherboard: Hewlett-Packard, 18A7
Antivirus: Norton Internet Security, Updated and Enabled

I am unable to open a password protected Excel 2010 file in Excel 2007.

When attempting to open this file nothing happens but on clicking the office button the New and Open options are available but all the other options are greyed out.

Using the open option has no effect on this file whatsoever.

I would be grateful for any suggestions.



A:Excel 2010 file will not open in excel 2007

Does is need to be saved in a different format. Wasn't there a change in the default around that time??

Read other 1 answers

I have tried to apply Themes to my Worksheet but the only thing that changes is the font. Color and Effects do not change.

Help Would be Appreciated

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 8.1, 64 bit
Processor: Intel(R) Core(TM) i3-4130 CPU @ 3.40GHz, Intel64 Family 6 Model 60 Stepping 3
Processor Count: 4
RAM: 8108 Mb
Graphics Card: Intel(R) HD Graphics 4400, -2016 Mb
Hard Drives: C: Total - 942195 MB, Free - 791640 MB; D: Total - 476813 MB, Free - 10813 MB;
Motherboard: Dell Inc., 088DT1
Antivirus: McAfee Anti-Virus and Anti-Spyware, Updated and Enabled

A:Themes Not Working in Excel 2010

Funny, I never in my entire Excel time used themes, I just tested it on my also 2010 version and nothing happens except to the font, but ....

I tried some more, let's say to change the header row and do something with it
Make the header row background grey with bold black font.
Now apply a theme then you'll see it change to the colors of the them.
If I understand correctly a theme is that. it applies to all things you do extra to a sheet.
If you create a table and things like that and then apply a them you'll see not only the font change but the rest too.
I guess you'll just have to dig a little deeper, I just found this out in the past 5 minutes
Good luck

Read other 1 answers


I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns.

It's a cinch when drawing a table in MSWord (2003) so I cannot imagine why this should not be possible in Excel, but then I don't know everything

Thank you

A:Formatting Excel 2010, Excel 2003

If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.


Read other 5 answers

Hey all,

I'm having an issue with the Xerox Workcentre 7120 and Excel 2010. I simply cannot print Excel files whatsoever. It tells me that the document has been sent to the printer, yet two minutes later it tells me that the print job has failed - no reason given, it just says in the Completed Jobs tab that it was cancelled. When looking at the Completed Jobs tab on the printer itself, it tells me that it was "Completed-Error" - basically meaning that nothing happened. I'm running Windows 7 64-bit.

I've tried many fixes, including restarting the PC, restarting the printer, restarting the print spooler, reinstalling Office 2010 completely, installing another driver for the printer, running a repair on Microsoft Office 2010, reinstalling the printer completely (it's a network printer) and dancing around the PC in complete frustration whilst chanting (the last one helps a lot, strangely enough).

The weirdest thing is that it's just an issue with Excel - Word, Office and other Office programs print fine with this specific printer. Does anyone have any suggestions? I've tried printing to another printer in another part of the office, and that works perfectly fine. It's just a hassle having to go through multiple doors and parts of the office to retrieve a simple document.

Read other answers

I've got an issue / question that I cannot figure out why it happens.
I have attached a asample file to illustrate it.
There are three coloured cells.
The yellow colored cell has nothing, the green colred cell has Data Validation for a List and the blue colered cells has data validation for a whole number between 0 and 10

I added a ... BefodeDoubelClick action to display something, in this case a Message Box.

If the sheet is unprotected, the message box is displayed if one of the selected coloered cells is doubleclicked.

There are 2 buttons, one to pritect and one to un protect the sheet

However, If the sheet is protected, the cell with tha Data Validation List (green) will not trigger the action to display the message box.
If you select this cell and double click elsewhere on the sheet it will work.

Anybody know why this is?
Just curious.

A:Solved: Excel (2010) BeforeDoubleClick not working when sheet is protected

Guess unprotected sheet is like "Design mode".
Once you protect it, only "view mode" is possible for the drop down list.

Read other 2 answers

I'm working on an Excel project of mine and wanted to use VBA to create a Data Validation List in a merged cell.
The strange thing is that using VBA for some reason the list does not show as a drop down list but as a long string
The string is the 26 letters of the alphabet
Click to expand...

Since I was doubting my own VBA code I decided to record a macro and added all the 26 letters of the alphabet
The resulting code:


Sub DVApply()
' DVApply Macro
With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End Sub

Now here is the thing. The moment I record the macro the list shows up nicely as a dropdown list, but if I run the macro the new list will show up again a a single string and not in a list unless I open the Data Validation Dialog and click Apply and close it.
I&#... Read more

A:Solved: Excel (2010) Data Validation using VBA not working as expected

Whatever the problem is I wrote another routine and it works now.
I've thrown every range at it and it (still) works.
I'ts still strange why even the recorded macro does not work when you run it again afterwards.
Let it be, one more of Microsoft's deep secrets
At least this post had 15 views, but I'm marking it solved.

Read other 1 answers

ms office excel 2010 symbol not working to insert on page, , all the symbols when you press " insert " symbol and the character box opens.in microsoft excel and word. what might be the issue....

A:Ms office excel 2010 symbol not working to insert on page

Please we need a little bit more information. What symbol? What page?


Read other 1 answers

Hi all,

Ive got to do some statistical analasis for work, I need to search 2 columns for 2 different types of data and collate.

For example search for "a system" in A:A & "a reason" in F:F which matches the critera fount in A:A

I have office 2007 at home which was fine because I just used the "=COUNTIFS" formula and it worked fine, but I then saved to 97 format because thats what they use in work and the "=COUNTIFS" formula is not back compatible.

Is there any way I can do this with 97, any help would be greatly appreciated.

A:Solved: EXCEL 97 "=countifs" alternative needed

Read other 9 answers

I'm hoping someone can help me with a small project I have.

Essentially, I want to create a spreadsheet using Microsoft Office Excel 2010 that would act as a time-sheet. It would have two columns - the first being a start time and the second being an end time.

So, a cell in the first column might say 8:30am, while a cell in the second column might say 5:30pm. What formula or method do I need to use to have a cell in the third column automatically tell me how many hours were spent in that time (9)?

Any help would be greatly appreciated.

A:Solved: Working Out Hours Between Start And End Time In Microsoft Office Excel 2010

Read other 14 answers

Hey all,

I have come to you in a fit of desperation. My USB drive was stolen recently and my master Excel data file was lost, which contained all my compiled data from my most recent lab experiment.

Anyway, I have charts of all the important stuff in a word document. The data is there, I can hover on each data point and see the values, and the axes and chart are all accessible for editing.

My question is, how the heck do I extract that data back out of the chart into a table or Excel spreadsheet? There MUST be a way that is better than copying down each data point one at a time

Your help is greatly appreciated.

A:Excel chart in Word 2010: extract chart values? Lost Excel data file!!!! Help.

Hi welcome to the fourm.
I don't know it reverse engineering is possible.
Something like convert chart to table?

One thing you could try is copy the chart back to a new Excel file and see if more is possible there than in Word?

Like I said never needed this. Have you googled for something like Excel data reverse enginieering?
Maybe something come up.

Read other 1 answers

I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In other words, I want to keep all my other Office applications (Outlook, Word, etc running as 64 bit versions but in the future run Excel in only the 32 bit version.

I'll appreciate your help with this very much!
/ Gary E.

A:How to go back from Excel 2010 64 bit to Excel 2010 32 bit

What exactly are the options shown when you run setup? Do you have an option for completely uninstalling Excel?

As I recall, MS recommends the 32 bit install and I think it is the default. Did you have some specific reason to choose 64-bit?

Have you seen this:

How to Downgrade Office 2010 from 64-bit to 32-bit ? My Digital Life

Read other 6 answers

Firstly I am a beginner of beginners but I try to learn as much as I can.
I have put the following protection code into an Excel 2003 workbook and everything runs ok. I then opened the workbook in Excel 2007, and saved it as a .xlsm file. When I try to open the .xlsm file in Excel 2007, I get a vba Runtime error 13, "Type mismatch", and the code sticks at the first line below("If Worksheets...). I have tried everything that my limited knowledge allows, searched the web for 2 days, and still have no answers.
Any help would be greatly appreciated.

Private Sub Workbook_Open()
If Worksheets(28).[A51] > "" And Worksheets(28).[A50] = Worksheets(28).[A51] = False Then
MsgBox "Sorry, this program is not registered for this computer, please e-mail .......... for more info."
Application.DisplayAlerts = False
End If
End Sub
My system specs are shown below.

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3 CPU M 380 @ 2.53GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 2934 Mb
Graphics Card: Intel(R) HD Graphics, 1243 Mb
Hard Drives: C: Total - 290143 MB, Free - 172186 MB;
Motherboard: Dell Inc., 0WXY9J
Antivirus: avast! Antivirus, Updated and Enabled

A:Solved: Excel 2003 vba code not working in Excel 2007

Read other 16 answers


Need assistance on the below Excel issue.

When we open excel file, other minimised excel files get maximised, help me with the resolution.

Read other answers

Is anyone good at using excel? I need help with making an input box that will allow me to enter numbers, And these numbers will automatically register with my other work sheets in my work book.

A:Excel 2013

Read other 8 answers

I'm running Windows 7 Professional and just upgraded IE from 9 to 11. Afterwards, I observed that Outlook 2010 was not downloading pictures (instead showing red x's) and Excel 2010 embedded internet queries stopped working. 
I think I've cornered the problem, but can't seem to fix. I have also observed that IE's temporary internet files (TIF) folder may be missing (Internet Options>Browsing History>Settings>Temporary Internet Files shows nothing under Current Location)
and the allotted disk space is set to zero and cannot be changed. If I input another number (no matter the number), I receive the following error message:
"Please select a value between 8 and 8 for how much disk space Temporary Internet Files may use."
I have tried renaming the following RegEdit keys, but to no avail: Cache and LowCache (both under HKEY_CURRENT_USER>Software>Microsoft>Windows>Internet Settings>5.0). They get replaced when IE11 is re-opened.
The actual values within the registry keys are as follows:
Cache>Content>CacheLimit = 8192 (Decimal)
LowCache>Content>CacheLimit = 256000 (Decimal)
This is driving me crazy. Any help would be greatly appreciated. 

Read other answers

I'm running Windows 7 Professional and just upgraded IE from 9 to 11. Afterwards, I observed that Outlook 2010 was not downloading pictures (instead showing red x's) and Excel 2010 embedded internet queries stopped working. 
I think I've cornered the problem, but can't seem to fix. I have also observed that IE's temporary internet files (TIF) folder may be missing (Internet Options>Browsing History>Settings>Temporary Internet Files shows nothing under Current Location)
and the allotted disk space is set to zero and cannot be changed. If I input another number (no matter the number), I receive the following error message:
"Please select a value between 8 and 8 for how much disk space Temporary Internet Files may use."
I have tried renaming the following RegEdit keys, but to no avail: Cache and LowCache (both under HKEY_CURRENT_USER>Software>Microsoft>Windows>Internet Settings>5.0). They get replaced when IE11 is re-opened.
The actual values within the registry keys are as follows:
Cache>Content>CacheLimit = 8192 (Decimal)
LowCache>Content>CacheLimit = 256000 (Decimal)
This is driving me crazy. Any help would be greatly appreciated. 

Read other answers

Excel 2013 can't be opened on my Windows 8.1 laptop, can any Microsoft specialist help me?

Read other answers

Hi, I have a desktop win7 32 bit OS and installed MS Office 2013. I can print from ms word and other word application accept for excel. Every time I press print a message pops up saying "no printer found". I also cannot set the brother mfc 8910 printer to default printer, it displays a message "operation terminated"

How can I get excel to print and have the printer set as default?
Also I want to know where I can go to see the details / specs of ms office suit that indicates 64 / 32 bit?

A:ms excel 2013 not printing.

Read other 8 answers

Hi Guys,

Let me start off by stating that I'm still trying to learn all the juicy functions you can do with Excel, and I've just gotten myself a little project where I think I can learn but I need some kind of help from you guys.

Basically what I'm trying to do is somehow automate a creation of a report via excel, first method I thought of was to use macros, but since the data that'll be included in the report will be on a different cell each time, macro might not work as I imagined it to be, then I thought of the IF function, I have not yet tried doing that, but would that work? Can you please share your thoughts? Ask me any additional info and i'll try to explain it as simple as I can.


A:[HELP] Programming in Excel 2013

Your description is entirely too vague in order for anyone to offer any kind of help. Can you be more specific as to what kind of a report you want to generate and what data you will be using?

Perhaps you could post a sample of the worksheet with the data and a sample of what you want the report to look like.

Read other 2 answers

I'm trying to open an add in in excel 2013 and I keep getting this message
Compile error
The code in this project must be updated for use on 64 bit systems
Please review and update Declare statements and then mark them with the PtrSafe attribute
I have no clue what to do

A:Excel 2013 error

Most likely you have Office 2013 64 bits installed and the add-in only works on Office 2013 32 bits!

Read other 7 answers

That?s new to me and can?t find any answers on the web. The attached snip is from a workbook I made a few months back and all was ok but now as you can see the first row looks like its missing because there are labels on that row which I can?t see.

In addition, the heavy vertical black lines are not mine (when I click on them it says ?Oval Object #...? and there are 2 vertical rectangles which are not mine either.

The only explanation I can give is perhaps an update from MS change all that

If I copy this workbook as an Excel.xls and view it on my other laptop which has Excel 2000 all is normal and copying this normal workbook and open it with my Excel 2013 the same strange things happen again

Any idea how I can recover my original

Read other answers

Every day I send out excel documents that I then convert to pdf's. I use the same excel template on each document. The only thing that changes in each document per recipient is the "name" "company" & "email" fields in the excel document.

Question: Is there a way I can get these documents to interface with outlook so that when I select more than one person to receive the document (as many as 30 people will receive the same document), and auto populate the contact info "name" "company" "email."

This way would save me a few steps so that I don't have to pick a contact... type all their info in the fields... send. Select my next contact... enter appropriate info in the fields... and repeat and repeat.

I'm emailing job specific information to everyone working on the same job. I'm sending it to multiple people, but need it to look like they were the only one who received the document. Just like when you get an email about the "deal of the week" that says, "Dear Mr. Johnson, How's your summer going?.... " while someone in NYC gets the same letter that says "Dear Mr. Thompson, How's your summer going.... " from the same sender. Of course the deal of the week changes each week.

How can I make this happen? If there is a better way outside using excel to create pdfs, or a totally different method entirely. I'm all ears. I just need to send the informatio... Read more

Read other answers

I have a Toshiba P855 with 16GIGS of memory and Office 2013. I have been on the phone with Microsoft for 13 months complaining about how Excel 2013 Office Pro keeps crashing randomly. At first they told me my macro was corrupt. I knew it wasn't because it runs all day long on office 2010 on my desktop which has Windows 7 it was on and off with them for weeks and hours and they finally said that it has to be something wrong with my laptop. It will crash sometimes when I go to copy and paste simple task on a new spreadsheet without any Macros or no conditional formatting and it is real pain in the butt. When it does crash I can load that same file to my memory stick, open it on my desktop, close it, re open on my Toshiba Office 2013 and it runs for a while.

Is there ANYTHING that can be causing this from the laptop drivers or other programs. I'm at a lost and feel Microsoft once again is giving me the run around. It gives me different crash reports within excel too so they are not always for the same reason it crashes but when it crashes anything I have open within excel crashes too. It's ONLY excel that crashes. No other programs and my lap top is fine. It is NOT my anti virus. It will crash when I try and cut and paste ONE CELL

Things I have done, repair 3 times, removed and re installed twice, removed all add ons, changed printer spool, bring up in safe mode, reloaded graphics drivers, spoke to Toshiba, BTW Microsoft says its Toshibas fault and Toshiba says its Microsof... Read more

A:Excel 2013 has been crashing for over a year, HELP!!! Tried everything

Hi larbec7.

Read this MS website concerning your problem. Be sure to follow the link shown in the Answer section as it give a lot more info. See if there is anything there that helps you.

Excel 2013 is crashing sometimes with error 0xc0000005 - Microsoft Community

Read other 1 answers

Does anyone know why when I try to save some Spreadsheets in Excel 2013 I get a message saying there is a sharing violation and I have to save the file under a different name.

I am the only person using the computer and the Excel program.

Thanks in advance


Read other answers