Over 1 million tech questions and answers.

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

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

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!

RELEVANCY SCORE 200
Preferred Solution: Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

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: Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

Read other 16 answers
RELEVANCY SCORE 107.2

I'm sure this is a common request so I done a search in this site and was unable to find an answer. Could someone tell me how to turn off excel errors, like value, n/a, div/0 etc...

thx
 

A:Solved: excel 2010 errors

Read other 6 answers
RELEVANCY SCORE 104.8

I am in the process of assisting some users in switching from Win XP/Office 2003 -> Win 7/Office 2010 and have hit a roadblock. I have a user that has an excel macro that opens an ADO connection to a SharePoint and grabs a record of the excel files on the SharePoint. The macro works perfectly on XP/2003 and XP/2010 but fails on 7/2010.
They are using this connection line:

Code:
davDir.Open "", "URL=http://SharePoint/Directory/URL", _
adModeRead, adFailIfNotExists, adDelayFetchStream

Set davFiles = davDir.GetChildren()
Once they have the record they iterate through each Excel file on the SharePoint to open and parse them.

On Win7/2010 I get these errors when it gets to the davDir.Open line:

When they error trap it throws this error:






Quote:
Object or data matching the name, range, or selection criteria was not found within the scope of this operation.


Without error trapping it throws this error:






Quote:
Run-time error '-2147217895 (80040e19):Automation error


I can connect to the SharePoint fine via IE or File/Open in Excel 2010. I have tried every variation of the URL I can and I just keep getting the same error.

Does anyone have any ideas? The fact it works on XP/2010 screams Win 7 issue to me, but beyond that I am lost. I have spent the last 2 days scouring Google and I am starting to lose my mind.

Thanks!

A:Excel 2010 WebDav Connection to SharePoint Errors

I've had just this problem and have narrowed it down to making the connection. The following code produces the same error on SP 2007 from Win 7:

Dim Conn As New ADODB.Connection
sURL = "http://sharepointtest2/personal/kraviss/Test docs/ACT Contracts Data" RepositoryRepository"
Conn.Open "URL=" & sURL


I've found WebDav to be most unreliable when uploading files to SP doc libraries and a little less unreliable when reading properties. I use the Frontpage Server extensions to do most uploading. FilesystemObject calls work most of the time to get file and folder properties - the following code fragment will get folder contents. sFolder is the UNC path for the SP doc library

Dim objFSO as New Scripting.filesystemobject
Dim objFolder as Scripting.Folder
Dim colFiles as Scripting.Files
Dim colFolders as Scripting.Folders

sFolder = "\\sharepointtest2\personal\kraviss\Test docs\ACT Contracts Data"
set objFolder = objFSO.GetFolder(sFolder)
set colFiles = objFolder.Files
set colFolders = objFolder.Subfolders

This will need a reference to Microsoft Scripting Runtime scrrun.dll in C:\Windows\SysWOW64

Read other 1 answers
RELEVANCY SCORE 103.2

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 103.2

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 102.4

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 102

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 100.8

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 100.4

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 100.4

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 100.4

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 100.4

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 100

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 100

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 98.8

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 98.8

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 98.8

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 98.8

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 96.8

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

Hello,

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.

Cheers

Read other 5 answers
RELEVANCY SCORE 96.8

Help! I would like to convert to computerized recordkeeping. The only software available to me is Office 2010 suite. I have created an Access 2010 budget database that includes purchases, vendors and users. I also have created an Excel 2010 spreadsheet with beginning budget amounts and purchases that works very much like a checkbook. However, I don't want to have to enter information in both. Early next week, I have to produce a report that shows what percentage of our available budget we are spending on a vendor. This report will be used as a visual to ask for more money. Any suggestions on the best way to do that for a someone who is not familiar with VBS or SQL or any other real techno language?
 

A:Access 2010? Excel 2010? or both?

If all of the information is in Access already just create a report based on the vendors and money spent with each. You can easily do this if the data is set up correctly in the database.
 

Read other 3 answers
RELEVANCY SCORE 93.6

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

It seems that there may be a problem in Office 2010. I just installed it to the standard MS default/recommended settings .........all looked good...used Word great..until I use Excel and each time I try to use excel it sets off an 'Office Configuration' screen which I can not stop..it take a few minutes and then loads OK. I tried to launch it from the installed prgrams icon but there is no files on 'start in' etc..I tied to create a shortcut to the desktop from the excel.exe file and get the same reconfigure issue..it seem that somehow I don't have either permissions or I have a corrupt install..all Office suite works eventually Anyone know how to fix it..please?

A:Office 2010 Pro Plus Win7 x 64 Excel reconfigures Office 2010

Have you ever had a previous version of Office on this copy of win7?
or

Do you have any component of a previous office suite installed still

I have seen this in the past with Viso that was due to remnents of an earlier trial remaining on disk and in the registry.

I also found that if I cancelled the configuration screen the Viso would load without problems without the need to wait for completion.

There are some rather involved solution stems on Microsoft website - cannot find them at the present but will try to look for them.

The problem was that I could never get the removal steps to actually cure the issue and I put up with the error until my next re-install of Win7, which was not to long in the case of that system

Read other 6 answers
RELEVANCY SCORE 88

Hello. I am having an issue with formulas. Whenever someone emails me a spreadsheet or if I open a previously done spreadsheet that I have not opened before, there are formula errors thru-out. Some are just simple addition. What is the cause of this and how can I fix it? Also, my co-worker and I have the same Excel versions and it still comes up. Thanks!
 

A:Excel 2010

http://chandoo.org/wp/2009/04/20/excel-formula-errors/

need to know what the errors are
 

Read other 1 answers
RELEVANCY SCORE 88

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 unique names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!

A:Excel 2010 help

Hi,

Seven Forums is an excellent place to get answers. But sometimes, you might find that there is a more focused, dedicated forum for a specific topic, such as in this case.

One of the best excel resources with a bunch of extremely helpful people is at MrExcel.com | Excel Resources | Excel Seminars | Excel Products.

Jump on the forums there. I'm sure you will have your answer very quickly.

good luck
Tanya

Read other 2 answers
RELEVANCY SCORE 88

I wanted to see if there is a way to add next invoice number, once printed, to an invoice template I downloaded.

Also, I tried copying Original Copy Sheet to the Customer Copy Sheet & File Copy Sheet but if the Original Copy Sheet doesn't have information in it, it copies "0" which I would like to stay blank. How do I do that? I was using = and clicking on that certain cell.

I tried VBA and enabling macros, but I didn't have any luck.

Please help.
Michele
 

A:Excel 2010

Hi,

Here's a simple code to increase the invoice.
Code:

Sub Update_Invoice()
Sheets("Original").Range("K12").Value = Sheets("Original").Range("K12") + 1
End Sub
 

Read other 1 answers
RELEVANCY SCORE 88

Hi Guys,

I have an issue with my Excel application. Every time I open Excel and click on File from the menu bar the application keeps freezing. I can click on the other menu bars but not FILE.

I have tried safe mode, re-installing the the whole MS Suite, and repairing and nothing worked.

Does anybody have some tips for me.

Thank you,
 

A:MS Excel 2010

I found this article that may help you:
https://support.office.com/en-us/ar...-working-37E7D3C9-9E84-40BF-A805-4CA6853A1FF4

Failing that you could contact Microsoft themselves if you believe it is a problem with their software:
https://sales.liveperson.net/hc/216...21661174&SESSIONVAR!campaign=officeUniversity

The last idea I have is to make sure your Anti-virus and Malware software are up-to-date and working, in case that it causes a problem. Although that might be more than just the one program.

Hope this helps
 

Read other 1 answers
RELEVANCY SCORE 88

When I click on my Excel 2010 shortcut instead of Excel opening I get a Windows message asking if I want to allowthe Programme to make changes to my computer. If I click 'yes', Excel opens but with a blank blue screen in the working area instead of the normal grid. Likewise if I click on an Excel attachment in an email the same thing happens. To open an Excel document I have to go to the main Microsoft Office section in Programmes and click on Excel. This has only happened recently. Any ideas on the cause of the problem and on a solution?

Many thanks.
 

A:Excel 2010

Try System Restore - choose a restore date which precedes the date when the problem was first noticed.
Start >> All Programs >> Accessories >> System Tools >> System Restore
 

Read other 1 answers
RELEVANCY SCORE 88

I have a spreadsheet for my family expenses and I would like to make excel to send me a email when a payment is due. If it is possible like 5 days before the due date. And also tell me which bill that I have to pay.
 

A:excel 2010

Are you going to have Excel running at all times?

You can do it with VBA... but not sure it would make any sense or actually work, as Excel isn't generally running and I don't expect anyone to run VBA every day.
 

Read other 1 answers
RELEVANCY SCORE 88

Hi all
I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares.

I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit / Loss.

The advantage of having it on the spreadsheet is then it's all in the same place.

The spreadsheet looks something like this -- enclosed pic

I'd like to embed the calculator in column M say starting at Row 15-- I'm not sure whether this should be done with a FORM or embed another spreadsheet.

Any ideas / links --- all the googling I've done either quote examples that are so impossibly complicated or hard or just too basic.

Cheers

jimbo

A:Excel 2010

It is possible that there already exists a function formula for the purpose:
Excel functions (by category) - Excel - Microsoft Office

e.g. PV - Returns the present value of an investment
Edit:
I just came across this, which might also be useful:
Excel VLookup Function and VLookup Example

Read other 9 answers
RELEVANCY SCORE 88

When trying to open Excel 2010 file "Excel cannot complete this task with available resources. Choose less data or close other applications."
Anyone else having this issue?

Read other answers
RELEVANCY SCORE 88

Hello,

I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them.

I have gotten these two messages:

1) Excel cannot complete this task with available resources. Choose less data or close other applications.

2) Excel found unreachable content in "XYZ.xlsx". Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

3) Excel cannot complete this task with available resources. Choose less data or close other applications.

This is what I did until now trying to fix the issue.

Fully updated the system
Upgrade RAM from 4GB to 8GB
Upgrade from MS Office 2007 to MS Office 2010
Re-image the machine and re-install MS Office 2010

Any ideas what else could be causing errors when opening excel? I'm using a Dell machine, W7 professional 64 bit, 8GB RAM.

A:Excel 2010

What happens if you start with a fresh XLSX file and fill it with similar data?

Do you have an XLSX file that is causing this problem that you can attach to a post?

Read other 5 answers
RELEVANCY SCORE 88

I have created a worksheet which I need to expand to fit an A4 page for printing. How do I go about it please?
 

A:Excel 2010 help

Select File > Print >Settings, Choose A4 Paper and change Scaling to fit to one page.
 

Read other 1 answers
RELEVANCY SCORE 88

Need some help in excel please
Got this project where i need to make a table in excel with info innit and such but the words are too big so it looks bad as pic related
How do i make it bigger?
 

A:Need help in excel 2010

Hi, welcome to the forum.
You can cahange the columns width, you kan change the font sieze.
Could you be more specific?

You can select the 4 columns and then double click in the border between A and B to autofit.
Because you are using the autofilter you van also increase the column width a little, but with your info it's unclear what you really want / need

SVP duidelijk uitleggen
 

Read other 1 answers
RELEVANCY SCORE 88

For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?

A:Bug in Excel 2010?

How have you set the default font. You can set the Default Font by opening Excel, select file & then Options & under General there is a Sub Heading "When Creating new Workbooks" & there you will see "Use this as the default font". Then you can use the drop down list to select the font & size. If you change this it will only operate on any new workbooks that you create. Any previous ones will remain in the font that was originally used.
I use Excel 2013 so this info comes from that, but I think Excel 2010 is the same or very similar.

Read other 8 answers
RELEVANCY SCORE 88

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 unique names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!

A:Excel 2010 help

I'm not sure I understand 100% what you are trying to do; however, I think you could achieve this using a VLOOKUP function.

Read other 3 answers
RELEVANCY SCORE 88

Hello,

I have an excel (2010) spreadsheet with 14 associates, we have to taken coporate courses throughout the year. I would like to have an email message automatically go out to that person on the date in the cell (cc'd to me). Also, maybe have that cell change a color a week before the date. I will send you the form, maybe I need to change the format of the form? I really appreciate your assistance. We use Lotus Notes not Outlook. My system here at work is the following:
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1977 Mb
Graphics Card: ConfigMgr Remote Control Driver, 1024 Mb
Hard Drives: C: Total - 238472 MB, Free - 196882 MB;
Motherboard: Hewlett-Packard, 3048h
Antivirus: None

 

A:Excel 2010

Since you've found the correct forum for your inquiry I'll go ahead and close this duplicate.

Continue here: http://forums.techguy.org/business-applications/1096917-send-email-excel-conditional-format.html
 

Read other 1 answers
RELEVANCY SCORE 86.8

Hi guys,

I need to sort some data in an Excel sheet, preferably just by the click of the a-z button, can you pre-define an area that you would like to sort, because I do not want the whole sheet sorted (however the number of rows can vary daily)

I hope the above made sense to anyone!

Any help/advise appreciated!

mad-martin
 

A:Excel 2010 sort

Read other 7 answers
RELEVANCY SCORE 86.8

Hello all,

In Excel 2010 there are many formats for cells in Home > number group > drop-down list. And also by Format Cells dialog box.
My question is, why we use those formats? Is there any benefit for it please?

A:Formatting in Excel 2010

What is "number group"? I don't see that on my Excel 2010 screen.

Are you asking why cells can be formatted in many ways?

Personal preference is one reason.

More explanation needed.

Read other 6 answers
RELEVANCY SCORE 86.8

Attached is a excel spreadsheet. What I have been working on is a formula that would do the following; If sheet1 A2=sheet2 A2 and sheet1 C2=sheet2 C2 then copy sheet1 to sheet 2 for that row from D to J.

Hope I have explained it well enough.

Thanks,

Derald
 

A:Excel 2010 Formulas

Read other 7 answers
RELEVANCY SCORE 86.8

Hi i am trying to create a macro that clear's contents in an excel file for 5 seperate tabs. When i run the macro i get a run time error 1004 and select method of worksheet class failed. Does anyone know what is wrong with the code or what the correct code would be for the macro to run succesfully? I pasted below the code from the macro:

Sub ClearContents()
'
' ClearContents Macro
'
' Keyboard Shortcut: Ctrl+d
'
Range("A2:B2").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Range("A2").Select
ActiveSheet.Previous.Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Range("A9").Select
ActiveSheet.Previous.Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
Range("A9").Select
ActiveSheet.Previous.Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
Range... Read more

A:Macro excel 2010 help

Read other 7 answers
RELEVANCY SCORE 86.8

I was just wondering if anyone might happen to have any idea as to how to get Excel 2010 to calculate a formula and to print the value.

I'm trying to to take the standard overtime and hours worked formula and put it into Excel, but so far I'm not having any luck with it.

It should look at the number of hours that you worked in a week and it should calculate the number of hours by your pay rate and show how much you made. If the hours are over 40 then it should calculate the number of hours that you worked over 40 and multiply that by 1.5.

Ideally it will also take the over time pay and add that onto your regular pay so that you can see as to how much your gross pay is supposed to be.

Either way the formula should should you your gross pay based upon your pay rate and the number of hours that you worked.

I'm trying to simplify things in Excel so I can get a much better idea as to whether or not I am being paid properly by my employer.

Most weeks I don't go over 40 hours, but sometimes I do go over 40 and I want to be able to get a much clearer picture of where I stand each week.

I should be able to set it up so that the only thing that I have to enter in each week is the number of hours that I work. It should be set up so that it calculates everything else automatically and shows me the result.
 

A:Excel 2010 Formula

Hi there,

I've uploaded an example file which utilizes a Table with the formulas I think you're after. Let us know if this helps.

HTH
 

Read other 1 answers
RELEVANCY SCORE 86.8

I'm searching through a list of records in an excel spreadsheet and have tried using the ms query but I can't figure out how to customize it so it'll take values as input from another excel sheet. I want to be able to type in field A1 - apple and have it display all records matching this from a specific Column.

Thanks,
Chris
 

A:Excel 2010 MS Query

I assume that you already have a query which you saved someplace?
You can ricght click on the cell where the query points to, and edit the query, then it's just normal sql query.
Normally the results are put starting in cell A4.
What you could do is have it filetr depending upon the data typed in cell A1, so the query looks at the value = the value in A1.
An example of what the query looks like:
Code:

SELECT SUPPORT_TPROBLEM.PWEEKNO, SUPPORT_TPROBLEM.PDAYNO, SUPPORT_TPROBLEM.PHOUR, SUPPORT_TPROBLEM.PISSOLVED, SUPPORT_TPROBLEM.POCCURRED FROM MARVAL.SUPPORT_TPROBLEM SUPPORT_TPROBLEM WHERE (SUPPORT_TPROBLEM.POCCURRED[COLOR="Red"]=RANGE("A1")[/COLOR]) ORDER BY SUPPORT_TPROBLEM.PWEEKNO, SUPPORT_TPROBLEM.PDAYNO


Ignore the query itsslef just see the red Range("A1") that is value to use
You can alos replace this with something like this:

LIKE(* & RANGE("A1") & *)

Then ik will look at everything where the value in range("A1") is somehwre in that field

I hope I've been able to explain myself, else just attach the query
 

Read other 1 answers
RELEVANCY SCORE 86.8

Hi is it possible to lock columns and rows together so when i sort a spreadsheet i make sure all the rows and columns are sorted together and i dont leave out somthing

Regards

A:Excel 2010 sorting

Yes - highlight all the data by selecting all the columns, or highlighting all the data before sorting.

Read other 3 answers
RELEVANCY SCORE 86.8

I am trying to auto fill some results on excel 2010 but its not working.

I inputted my formula to subtract the annual taxes J5 by the rebate amount K3 and create a new result called after rebates K5.
There are different amounts ranging from J5 - J9 and I put the formula on K5 as =(J5-$K$2).

When I double click the bottom right corner to auto fill ; It fills the boxes in the same result as What I have on K5.

I have attached a print screen on the problem for further clarification.
Here

or copy and paste this link

http://a8.sphotos.ak.fbcdn.net/hpho...734888_100001333447359_613481_624996146_n.jpg

Please advise

Thanks
 

A:HELP!!! Excel 2010 Autofill

What's in the formula?
Are all the formula's identical?
Maybe you copied instead of dragging the formula down
If the formulas are all identical you probably made a mistake.
 

Read other 2 answers
RELEVANCY SCORE 86.8

Hi! I am new to this sight but have read thru several threads to try and find what I need. But, although have found similar, have not found just what I need. Several years ago I designed a spreadsheet in Quattro Pro that did several things. First, after the data was either input or copied in from another source, it sorted the columns in descending order. Then it compared the value in B5 to list in D, if it was equal it went on to the next value in B6 and compared to the list in D. If the value in B was not in D, then it would place the value in E6. This continued down until all the values in B were compared. The result was a list in Column E that had all the values that were not in B. I used a method using range names and kept changing the ranges after each comparison. I even went so far as if the values were in both it would put a check mark in column A and C for the matching items. I did this buy greating small macros and then branching to another macro from within the current macro. I am at a point where I need to change this over to Excel instead of running it in Qpro and then opening it in Excel. Unfortunately the macros do NOT carry over from Qpro to Excel. I'm sure there is probably an easier way to do all this in Excel, but I'm not sure how to do it. Any help you could give would be much appreciated. I have attached a zip of an Excel sheet that contains the Qpro macros for you, if it helps. In Qpro, once the data is in, all I have to do is ALT-H and the macr... Read more

A:Excel 2010 formula help please

Read other 14 answers