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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I just got a 60 day trial of MSO 2010 instead of using MS Works 9.

1&#9644; I know I'm going to feel stupid after seeing a simple logical answer to this. If I create a spreadsheet & save it as a template. Then open it later to use as the form I created for. What happens to the template after I save my filled in form on it?

2&#9644; One of the problems is getting formulas messed up on L1 & L2 after a Sort. Which requires fixing & dragging the handles all the way down each column again.
My remedy has been to mark L1 & L2 unusable and not to highlight them for sorting.
Would be nice if someone knows shortcut to dragging handle down 100 rows.

3&#9644; Is there a way to stop showing trailing total after the last row with a useful total? Ex: 100 row sheet, the total on L13 is 59.70 and there is no need to have 59.70 showing all the way down to L100.

I'll try attaching a partial copy.

Thank you for your help
 

A:MS Office 2010 Excel

When working on a template, provided you give the finished document a different name when saving it, the template will still be available for later use and will remain unchanged.
 

Read other 2 answers
RELEVANCY SCORE 86.8

Hi There,

What I have is a spreadsheet with several sheets. I have created a summary sheet that I want to pull all the active information out if it meets a certain criteria.

I have the formula's put together so that it pulls the info correctly, but I need to know how to format the page so that it auto sizes the number of rows shown. I did it once before abotu 4 years ago.. but I can't figure it anymore.

I hope I'm explaining myself well. but here is a second go just in case. The formula to pull the data from each sheet is placed on the entire sheet (so that when that cell is populated the summary sheet will update) but I don't want the summary sheet to show hundreds of empty cells until they meet the criteria, I'd like it to only increase what you can see when they are populated. Thank you!!!
 

A:Solved: Excel Help 2010

Read other 7 answers
RELEVANCY SCORE 86.8

Hi
I am looking a a workbook containing survey data for a building. The data is organised by floors/rooms.
I want to use a pull down menu to allow users to pick the room they want to look at and then a macro which copies that information into the text filter function.
This works well with static text, but I need help with making this work with text changing depending on the choice made from the pull down menu

Any help greatly appreciated

PG
 

A:Excel 2010 Macros

Hi,

Welcome to the forum.
It would help if you provide a copy of your workbook.
 

Read other 1 answers
RELEVANCY SCORE 86.8

I have a user receiving the error "Excel found unreadable content in 'filename.xlsx". Do you want to recover the content of this workbook? If you trust the source of this workbook, click Yes."

I had her try opening the file in text pad and then creating a new Excel spreadsheet with the same information in it. I checked to make sure all add-ins were enabled. I verified she was not using macros or any complicated formulas in the file. The file is not showing up blocked under the security area of General tab. It seems to happen with files under that specific format but does not always happen to all of the files of that format. Even if she has multiple copies of the same document the same issue will come up. If we try clicking yes, it tries to repair but then fails to open anyways. I tried looking on the Internet for other solutions and have not been able to find anything.

Any help or advice would be much appreciated
 

Read other answers
RELEVANCY SCORE 86.8

How do I find the Version number for Excel 2010?

(For older versions I could just click on Help/About and see it.)

Your advice will be greatly appreciated. / GE

A:Excel 2010 but what Version ?

Hi,

If you open up Control Panel then click Programs and Features then 'Uninstall a Program' you can scroll down to the Microsoft Office you have installed then left-click once and in the status bar it'll show the installed version. This version number is carried through all the apps install in MS Office.


OS

Read other 4 answers
RELEVANCY SCORE 86.8

Can someone please help me to write a macro to assign to a button on a form that prints a copy of the excel page and saves the workbook to a specific file (Network/ESL-DC01/Datastore/Shared/Orders Placed) and uses the contents of a specific cell (E5) as the saved file name, when the button is clicked.
I think there might be a way to do this but it's driving me mad. Any help would be much appreciated, many thanks.
 

A:Help with macro in excel 2010 pls

I'm not an expert, but this code worked fine...Of course, you need to create the button and assign the macro PRINTandSAVE....Also, before you try it out, change the Path I used for the one you need.

Sub PRINTandSAVE()
'
'
'------------
'Print the Active Sheet
'------------
Set ws = ActiveSheet
ActiveWindow.ActiveSheet.PrintOut
'------------
' Save a copy of the workbook
'------------
Dim CSName As String

'This is the cell (E5) containing the name for the new book.
CSName = Worksheets("Sheet1").Range("E5").Value

ActiveWorkbook.Sheets.Select
ActiveSheet.Activate
'below, you should type the path where you want to save the file
ChDir "C:\YourPath\"
'Save the new workbook.
' FileFormat := 52 allows to save the Workbook containing macros
ActiveWorkbook.SaveAs (CSName), FileFormat:=52

'Close the original workbook, do not save. Remove if not needed
ActiveWorkbook.Close (False)
End Sub
hope it helps
 

Read other 3 answers
RELEVANCY SCORE 86.8

I am unable to add a new tab or rename a tab in an Excel document as the person who created it has locked it to prevent unwanted changes. That person no longer works for the organisation & isn't accessible. It says I need permission to be able to make any changes.

How do you change the permissions when the document creator is no longer available/has left the organisation? Is this possible? Or can only the creator do this?

Thanks for any help!
 

A:Excel 2010 permissions

http://www.online-tech-tips.com/computer-tips/3-ways-to-unlock-a-protected-excel-file/
 

Read other 1 answers
RELEVANCY SCORE 86.8

Installed Excel 2010 (XP OS). Upload spreadsheets saved in Excel 2010 to a web site. On my computer I have a Table of Contents index with the links to those spreadsheets. This ToC has also been saved in Excel2010 and the links changed to .xlsx. But when I click the link on the ToC, it won't download the spreadsheet. The documents are downloading as a Zip file instead of a worksheet. When the Zip file is opened, it contains jibberish. All of the spreadsheets been saved as xlsx.

This is precisely the same method used with Excel 1997-2003 which worked beautifully.
 

Read other answers
RELEVANCY SCORE 86.8

i have office 2010. tried opening a excel document and wouldn't open. no error message. it showed for a split second and disappeared but never showed on the tool bar. i opened another excel document and opened the first document and it showed...anybody know why this may be happening?

A:microsoft excel 2010

Is the Excel program maximised when you open the document?

Read other 6 answers