Over 1 million tech questions and answers.

Excel 2013-2010 Problems

Q: Excel 2013-2010 Problems

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
16GB
250GB SSD
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
RELEVANCY SCORE 200
Preferred Solution: Excel 2013-2010 Problems

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

RELEVANCY SCORE 73.6

Hi,

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 !!!
 

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

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

Read other 1 answers
RELEVANCY SCORE 71.6

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
RELEVANCY SCORE 70.8

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.

File>
Share>
Email>
Send as an Attachment>

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

Read other 2 answers
RELEVANCY SCORE 68

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.
Code:

Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Temp Data\mydata.csv"
Rows("1:1").Select
Selection.Delete Shift:=xlUp
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="<>"
Cells.Select
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Range("A1").Select
ActiveSheet.Paste
Sheets("Mobility").Select
ActiveSheet.Range("$A:$AM").AutoFilter Field:=33, Criteria1:="="
Application.CutCopyMode = False
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Range("A1").Select
ActiveSheet.Paste
Range("AC2").Select
Application.CutCopyMode = False
Sheets("Sheet2").Select
Cells.Select
Range("U1").Activate
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Add Key:=Range( _
"Q:Q"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
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
RELEVANCY SCORE 61.2

HI Guys, tried uninstalling office 2010 to open Outlook 2013 when I got the two following errors:

1: The resource that you are trying to use is located on an unsupported version of Microsoft exchange. Contact your email administrator for assistance.

2: Cannot start Microsoft Outlook. Cannot open the Outlook window. The set of folders cannot be opened. Your Microsoft exchange administrator has blocked the version of Outlook that you are using. Contact your administrator for assistance.
Does anyone know what these two errors are referring to and how I can fix it so I can start using Outlook 2013?

Many thanks.

A:Outlook 2010 and 2013 conflicting. Can't open 2013.

Are you trying to connect to an Exchange mail server, e.g. one managed by your employer?

Read other 1 answers
RELEVANCY SCORE 56.8

Hello.
 
I'm making a new referral form for the company I work for to be used by the council. I'm having problems with the active X boxes in Excel 2010.
 
I work on a remote server but I don't think this would be the issue. On sheet one the boxes work fine and as intended however on sheet two the boxes on the left side are only usable once and while on the right side they work as they're meant to.
 
I have no idea why it's doing this so I thought maybe someone here can help me out. I've tried roaming the web as much as possible but can't find a solution to my problem. I have attached a picture to show which boxes I mean.
 

A:Having problems with ActiveX box's in Excel 2010

No one able to help?
 
I really am stumbed on this and would like to get this form up and running before scrapping it and trying a new one.

Read other 2 answers
RELEVANCY SCORE 56.4

I have recently installed Microsoft Office 2010 on a brand new computer running on Windows 7.

When I save a word document the only way you can view it is by saving it in Word document 97-2003.
When saving a spreadsheet in Excel, and you try to open it, it displays as a Adobe document which cannot be opened.

Can someone explain if I have done something wrong, and how do I rectify this problem.

Many Thanks.
 

Read other answers
RELEVANCY SCORE 55.6

Hi there,

In the attached spreadsheet, I'm trying to sum up the sales of a product line, by a particular sales rep, product and date. I'm getting an answer, that at first glance looks correct, but if I total up the yearly sales using an independent formula, I arrive at a different figure.

I think the problem is stemming from sales on the month-end dates, but I can't work out how to correct it. Any help would be much appreciated.

Note: At first glance the spreadsheet seems to contain confidential data. I'm happy it's not.
 

A:Solved: Excel 2010: Problems with SUMIFS and dates

Read other 9 answers
RELEVANCY SCORE 55.6

Morning,

I've been racking my brains about this one lately as we have more users switching over to Windows 7.

I'm convinced it's Excel causing memory problems, but I'm unsure.

When working with excel for a short time, we're unable to switch to any other window on the taskbar. It's as if Excel is taking priority over anything else that is open on the taskbar. For example, if we have Outlook, Internet Explorer & Excel open, when we click out of Excel to go into Outlook, nothing will happen, but it seems as if it's bringing the window up in the backgroud.

We can fix this by closing Excel and starting it up again, but alas, some more usage and it starts again.



Both Windows 7 and Office are right upto date.

Any ideas anyone? Your help is much appreciated.

A:Windows 7 + Excel 2010 causing taskbar problems

Hi,

Mmm, I have been using Outlook2010, Excel2010 and Windows 7 Ultimate x64 for a while now and never encountered this at all.

Are you able to nail it down any better? For example, do you get the same problems if Excel is NOT open? Is there anything in Group Policies that could be controlling this?

Have you tried using TaskManager or Resource monitor to see what is hogging the focus?

Regards,
Golden

Read other 4 answers
RELEVANCY SCORE 54

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
RELEVANCY SCORE 54

Hi,
I know this is probably an easy question, but I've searched repeatedly on the web and I can't find advice there or in the forums because I'm missing some kind of terminology.

I want to be able to highlight multiple words in Excel and see the home toolbar open every time I open a spreadsheet.
Longer explanation:
I'm using Microsoft Vista 2007 with Excel 2010. I use Excel to make quite a few spread sheets to study for school, and I often have to selectively highlight multiple certain words by hitting ctrl and holding ctrl while highlighting the words. Next I would underline all of the highlighted words. About a month ago it was working fine.
Suddenly out of the blue whenever I try to highlight multiple words by holding ctrl in Excel it won't work. Also, previously when working in excel 2010 the top menu bar would stay on home toolbar with all the option listed, meaning I could keep tinkering with the font uninterrupted. Now after underling just one word at a time the toolbar keeps disappearing with the File tab highlighted green, and I have to keep clicking back to the home tab, then click underline. Have to repeat highlighting each individual word,, clicking home tab, and then underlining. Ugh!
I would love to hear some advice before I tear my hair out in frustration.
 

A:Solved: Excel 2010 unable highlight mutliple words & toolbar problems

Read other 6 answers
RELEVANCY SCORE 54

Afternoon everyone!

As the title suggests, I have some issues with formatting the x-axis of a column graph (the graph is to show air consumption rate over a period of 30 minutes) in Excel 2010 (the file in question is attached). As you can see in the attached picture, the graph currently has the x-axis formatted such that it starts in the middle of the ticks. Ideally, I am looking for a way to start "0" from the y-axis intercept without shifting the graph as is currently the case when changing the horizontal axis options.

Could you possibly help me sort this out? I need to present it for a university project and I'd like to have the graph presented in this manner. It would also help if I could learn the method so I can do this in future. Thank you for your help in advance!
 

A:Solved: Problems fixing horizontal axis on column graph in Excel 2010

Read other 6 answers
RELEVANCY SCORE 54

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
RELEVANCY SCORE 51.6

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

Read other answers
RELEVANCY SCORE 51.6

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

Read other answers
RELEVANCY SCORE 51.6

I have MS Office Professional 2010 (Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access).  I needed to install MS Project 2013 for a class that I'm taking.
 
Long story short, I now cannot use my 2010 stuff.  The computer only recognizes 2013.  (Would have been nice if I had gotten a warning when I was installing)
 
How can I get back my 2010 stuff?  Do I have to re-install it?  If I do, are 2010 and 2013 compatible or incomparable?
 
Upgrading to 2013 for everything is neither desired nor an option right now.
 
Thnaks.

A:MS Office 2010 and 2013???

This article: http://office.microsoft.com/en-us/access-help/office-2013-known-issues-HA102919019.aspx?CTT=5&origin=HA103981695#_Office_%28release%29 should help you in uninstalling Office 2013 and fixing Office 2010.
 
As for having two Windows office versions on your computer SAFELY, you would need a dual boot system, one office version for each booting partition.  You could create a third partition for all the files you save so you could easily access them from either booting partition.
 
~ OB

Read other 2 answers
RELEVANCY SCORE 51.6

alright guys I am in need of your opinion i have heard good things about both Office 2010 and 2013, but I am not sure which one is better, I can get both through my college, but I am just not sure which one would be best to use thanks guys i really appreciate it a lot

A:Office 2010 or 2013

You better check into the fine points about the licensing terms.

Including these questions:

Can the product be installed on more than 1 PC at a time and are there any restrictions as to the type of PC: desktop, laptop, etc?

Is the product restricted to the first PC to which it is installed or can it be installed to any single PC in the future, without restrictions?

Do you get a factory-made retail disc or just a download of some type that must be burned to a disc?

Are there recurring fees, such as a monthly or annual charge? Or do you pay just once and never again?

It seems that Microsoft's goal in the long term is to drive everyone toward recurring fees, like a subscription that must be renewed for the software to continue to function. You can avoid that with Office 2010 if you buy the right type of license. I'm not sure about 2013.

And you need to understand which of the Office applications are included: Word, Excel, Access, Powerpoint, etc, etc. There are numerous packages with different names.

Functionally, you won't find major differences and can become accustomed to either.

I'd worry most about the licensing details.

Read other 9 answers
RELEVANCY SCORE 51.2

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
RELEVANCY SCORE 50.8

Not sure anyone there si an expert on using SAGE ACT 2013 but here is my issues. I had to rebuild preference in my ACT program. In doing thins I lost the ability to set up email in the ACT program. When yo go to use the ACT email setup wizard, it normally shows you what email programs are available. The is missing in the set up program. I have read and tried a number of things to get it to work, no success. Any answers out there.
 

A:2010 Outllook and Sage ACT 2013

Read other 16 answers
RELEVANCY SCORE 50.4

Hey Guys,

We have an issue where people are looking at PP presentations in 2013 and getting the error message or a big X in it, but if you open the presentation in 2010 it looks perfect, no errors or X's. I tried the disable hardware acceleration option, and opening a new PP and inserting and same deal. The quick workaround I found was that if I open the image in paint and than save it as a jpeg (which is already was) then I can insert it or drag and drop it. The files are on our network, and even when I re-saved them they were still on the network. Has anybody else seen this issue? By the way we are on Windows 7, plenty of memory, and SP1 (15.0.4569.1504). Any help would be much appreciated as I am flabbergasted (sp?) by this issue, thanks guys.

A:PowerPoint 2013 Not Displaying Images You Can See In 2010

These websites may help you.

PowerPoint 2013 not Displaying Inserted Photos - Microsoft Community

Powerpoint 2013 problem

Read other 7 answers
RELEVANCY SCORE 50.4

Greetings.
 
Have a friend with a relatively new Dell Laptop running Windows 8.
 
She purchased the Office 365 Home Premium, which I believe she now has to pay for annually.
 
In the About section (at least in Word) it shows that it is a "Subscription Product".
 
 
A Google search for details about this are dizzying.
 
I'm not really looking to bash MS over this latest incident, there are plenty of others out there doing that for me.   I'm just wondering if she can uninstall this version of Office and install Office 2010.  Does MS allow these sort of moves?
 
 
She's a newbie and is taking a class that uses Office 2010 and would like to use the same apps at home as she does in class.
 
And if you're thinking about posting a "well, it's not that different, tell her to learn 2013"...please don't.
 
She is not a computer person, has no interest in becoming one and would simply like to get the most out of her class.
 
She has access to a legal copy of Office 2010 but I wasn't sure how all this works since there has been so much confusion about Office 365 and the annual fee(s) and transfer issues.
 
Anyone out there done this already or know if it can be done?
 
Thanks in advance,
 
Winterland

A:Can I go back to Office 2010 if 2013 is already installed?

I'm not really looking to bash MS over this latest incident, there are plenty of others out there doing that for me.   I'm just wondering if she can uninstall this version of Office and install Office 2010.  Does MS allow these sort of moves?... She has access to a legal copy of Office 2010 but I wasn't sure how all this works since there has been so much confusion about Office 365 and the annual fee(s) and transfer issues.Yes, you should be able to remove Office 2013/365 and then re-install the license/legal copy of Office 2010.This assumes that the license for Office 2010 is not already installed on some other computer (unless it is a license that permits installation on multiple computers).

Read other 2 answers
RELEVANCY SCORE 50.4

Dears,
 
I spent 2 days trying to install Visual Studio 2008 through 2013 with errors during installation.
I got .Net verified without problems using the .NET verifier and also i ran registry cleaner and I run it as administrator however still cannot install it.
 
In Visual Studio 2008 the Dexplore is failing to install as step 1 and here is the log file attached.
 
thanks a lot!
 
 
 
 
 

Read other answers
RELEVANCY SCORE 50.4

Hi,
I've checked the archives but can;t find a relevant thread.

I currently have Office 2010 Pro on my laptop and am going to be purchasing MS Project. But am unsure which version is the safe bet.

Can I install Project 2013 on a laptop running Office 2010 or is that going to be a problem and I should stick with Project 2010?

I don't need the latest and greatest version of Project so for my functional needs Project 2010 will be fine, but I figured if I am going to buy it might be best to get the latest version?

Note: I did find something on another forum about Project 2013 using Sharepoint 2013 and that conflicts over-writes some sharepoint 2010 executables thereby causing issues with 2010 suite ... but I don't have Sharepoint on my laptop so doubt this is an issue in my situation.

Anyways whats the safest bet, I really don't want to deal with conflicts or software issues. Stick with Project 2010?

Thanks!

A:Office 2010 Pro compatible with Project 2013

Office 2010 is the first to be available as either 32-bit or 64-bit. I had to uninstall Office FrontPage 2003 [32-bit] before I could install the 64-bit version of Office 2010. I would imagine the same would hold true for all Office applications.

Read other 9 answers
RELEVANCY SCORE 50.4

Not sure what I did but I recently modified a document on our SharePoint and saved it locally. Now when I open that master document on SharePoint it opens the one I saved locally a while back and asks if I want to update the server. I've searched on various forums for a fix for this but have yet to find a solution.

How can I open these master documents on sharepoint without having it ask to update the server. I'd hate to accidentally save over the master document.

I'm using MS Office 2013, and SharePoint 2010.

Read other answers
RELEVANCY SCORE 50.4

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
RELEVANCY SCORE 50

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
RELEVANCY SCORE 50

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
RELEVANCY SCORE 50

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
RELEVANCY SCORE 50

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
RELEVANCY SCORE 50

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
RELEVANCY SCORE 50

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
RELEVANCY SCORE 49.6

I have a qualifying copy of Office 2010 Home and Small Business.

Recently I just claimed the offer. But how about the old copy? Will it be invalidated instantly if I install the 2013 version? I'm not sure if I will like my 2013, so would like the ability to go back to 2010 if possible.

A:Microsoft Office 2010 to 2013 upgrade offer.

I'd be a bit wary of Office 2013. I read that Microsoft has changed the licencing so that Office 2013 is licensed for a single PC only and that the license may never be transferred. Which means if you upgrade or buy a new computer, you need to buy Office again!

Here you go:
Microsoft: Office 2013 license is for just one PC, FOREVER ? The Register

Read other 16 answers
RELEVANCY SCORE 49.6

I have a user whom created a meeting while using Outlook 2010.
This user was upgraded to outlook 2013 on a new machine.(surface pro 4)

I had the user remote into their old machine and cancel their meeting in outlook 2010 and it worked fine no issue.

I ve searched online for something about this but couldn't find anything.

Is anyone else familiar with this issue? Looking for a permanent fix as having user remote into old pc to delete items is not what I want to be final solution.

Read other answers
RELEVANCY SCORE 49.6

I'm the IT Manager for a small, non-profit. I need roughly 35-40 licenses for Office, or an Open License that allows that many installs. In years past, I always purchased these things from TechSoup. However, we are no longer eligible. We are a 501(c)5, and organizations like TechSoup only give discounts to 501(c)3.

Microsoft's website directed me to several vendors, but they either tell me we're ineligible (given our charitable status) or they give me an outrageous quote, especially for our size non-profit. Dell, for example, quoted me $13,326 for 40 licenses.

Am I completely out of other options? Back when TechSoup still considered us eligible, I was able to buy a volume license key for Office 2007...same key for every install. Is that still an option, because it seems like Dell is just giving me 40 "off-the-shelf" licenses, aka 40 keys.

I'm frustrated, because I can't believe a non-profit this small would have to pay that much.

A:Looking to Purchase Office 2010/2013 (frustration mounts)

If you are dealing with that tight of a budget, might I suggest you consider switching to Apache Open Office. Functionality is pretty much the same.

Read other 6 answers
RELEVANCY SCORE 49.2

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
RELEVANCY SCORE 49.2

Tech Support Guy System Info Utility version 1.0.0.2
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.

Regards

Flynne
 

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
RELEVANCY SCORE 49.2

Hi

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:

https://support.office.com/en-US/ar...ions-EF163677-3195-40BA-885A-D50FA2BB6B68#bm4

https://askdrexel.drexel.edu/app/an...:-change-password-of-a-workbook-in-excel-2007

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

Thanks

eddie
 

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
RELEVANCY SCORE 49.2

If you're experiencing crashing with these Microsoft Outlook versions in Windows 7 and 8.1 and 10, you might want to read here:

http://news.softpedia.com/news/micr...b4011042-kb3191849-and-kb3213654-517011.shtml

--------------------------------------------------------------
 

A:Attention! Microsoft Outlook 2010 & 2013 & 2016 Users

I have the third update being rolled out this week via Big Fix. Curious to see what happens now. Regardless, thanks Frank.
 

Read other 1 answers
RELEVANCY SCORE 49.2

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
RELEVANCY SCORE 49.2

Hi,

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
RELEVANCY SCORE 48.8

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
RELEVANCY SCORE 48.8

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
RELEVANCY SCORE 48.8

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

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

Read other 7 answers
RELEVANCY SCORE 48.8

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.

Cheers.

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
RELEVANCY SCORE 48.8

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

Read other answers