Over 1 million tech questions and answers.

help about excel 2007,2010,2013 all.

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

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

RELEVANCY SCORE 200
Preferred Solution: help about excel 2007,2010,2013 all.

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: help about excel 2007,2010,2013 all.

File>
Share>
Email>
Send as an Attachment>

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

Read other 2 answers
RELEVANCY SCORE 73.6

Hi,

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

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

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

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

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

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

Read other 1 answers
RELEVANCY SCORE 71.6

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

Read other answers
RELEVANCY SCORE 70.8

Hi All,

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

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

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

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

HP Z240
Xeon CPU 3.30GHz
16GB
250GB SSD
Win 7 Pro

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

None of these have resolved the issues.

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

Any help anyone can provide is greatly appreciated!

Read other answers
RELEVANCY SCORE 68.8

Good day everyone and thank you for reading my post.

I'm in trouble and need help. I am a statistician that LIVES by Excel. And my Excel is broken. I had 2007 since I started by business 6 years ago. About a month ago Excel started crashing intermittently when saving work on my employee's computer. Then it started on mine. Our data is stored in the cloud through www.cubby.com. I have full antivirus protection on all my computers with N360 (never even 1 time used a computer without antivirus protection since the early 1980's). Never had a virus get through N360.

There is no rhyme or reason why the crashing is happening. It only occurs on saving, and happens intermittently. I open a sheet, save it as a different name (to keep the original sheet unharmed) and it crashes. I open it immediately again, try saving again, and it works. I have tried saving on different physical drives and there is no difference. I mainly work with a single spreadsheet template and that is the one crashing. It may happen with other sheets, but I really never use other sheets to test it with.

I upgraded to Office 2013 early December 2014, hoping that would fix things, and it doesn't.

When we try to reopen those same spreadsheets that we saved during the crash, we get an error message stating the file is corrupted and cannot be recovered.

My spreadsheet templates (I designed from scratch myself) are about 1.5MB in size and do have macros. The macros are ones I programmed myself, ... Read more

A:Excel 2007 & 2013 crashing when saving

Read other 10 answers
RELEVANCY SCORE 68

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 68

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 68

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

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

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

Read other 13 answers
RELEVANCY SCORE 64

I have some very large spreadsheets ( 7000K to 11150K in size ).
These were developed using Excel 2007 on a Windows XP 32-bit 2GByte RAM computer.
Encountered out of resoucres error message when trying to copy and paste formulae and formats.

Concluded computer did not have enough memory so upgraded to computer with
Intel Quad Processor
8 Gbytes RAM
Windows 7 64-bit
Excel 2010 64-bit

Problem still persists.
Spreadsheets have a great deal of conditional formating rules
Also a very large number of defined NAMES local to individual worksheets
Each spreadsheet ( workbook ) has approx 125 - 185 separate worksheets
Most have identical structure - each referiing to a particular date so data varies.
Huge number of formulae in each worksheet.

Can anyone give me some clues as to what is going on inside Excel 2007 / 2010?
 

A:Excel 2007 and 2010 out of resource issue

I'm not sure, I have large spreadsheets myself and no issues and my computer has less memory but maybe if you disable automatic calculation before running the macro's and turn it on afterwards it will help?

See link below for some code indication.
I turn off events when I change a sheet until the process is complete and turn it on afterwards

Application.EnableEvents = False
< code>
Application.EnableEvents = True

I don't know if it will make a difference for you, but it won't hurt trying it.
Don't forget to make a backup before you do it.
 

Read other 1 answers
RELEVANCY SCORE 64

    I have done this twice now, and still haven't figured out the resolution.  I have office 2003 installed on windows 7 pro machines. The users then try to open excel 2010 spreadsheets, and they wont open because they are not compatible. But there is an office 2007 patch. I know, I use it on all the desktops that have office 2003, but I forgot to in these two cases. 
  So once I have the problem corrected, I have the fix, and I wont do it again.
 
 The problem. The office 2003 .xls file wouldn't open. I decided the file association was missing so on the .xls excel spreadsheet I highlighted it then right click>Properites>change.
Then i go to Browse C>local disk>Program files (X86)>microsoft office>office 14>excel. The association is wrong. I have tried to uninstall office and re install, but that did not help at all. I realized after i did this that the office 2007 compatibility pack wasnt installed so i installed the patch, but that didn't help either.
 The problem is that the xls is trying to associate with the xlxs,... i think.
 
 I am basically trying to dis-associate the .xls with any program and start over. I thought that it might be a registry setting? I have no idea anymore. Any ideas? I can't be the only one who has ever done this?
 
Thank you in advance for any help you might be able to provide

A:Excel 2010~2003 to 2007 debacle

First of all, welcome to BC !
 
Try coming at your problem from a different direction. Go into Windows Explorer and pick on one of your Excel 2003 files - any one will do. In Windows Explorer RIGHT click on the name of this poor innocent file. In the menu that will open, click on 'Open with...', this will bring up the 'Open with' dialogue box.
 
In the centre of the box you will see an Excel icon. Do NOT click on this, instead click on 'Browse' at the bottom right hand side, and browse to excel.exe (Office 2003). The path is :- C:\Program files (or Program files(x86) if 64 bit systems)\MS Office\Office 11.
 
Office 2003 is listed as OFFICE 11. Here you will find an excel.exe file with the familiar icon beside it. Click on this to select it, then put a tick in the box on the other side of the 'Open with' dialogue box, the one that says 'Always use this to open files of this type'. You have just changed the attribute of all the Excel files in your system, and they should now all open in Excel 2003.
 
You are correct, you need the 2007 compatibility pack to open 2007 and later files in 2003, and there will be a pause of a few seconds while the software translates from .xlsx to .xls, but it always works for me.
 
Chris Cosgrove

Read other 6 answers
RELEVANCY SCORE 62

I have an excel spread sheet that pulls data from multiple seperate sheet to then consolidate them into a single table that then uses a pivot table to pull together a 'class' list of everyone starting a set classs on the same day and venue with their contact details on including a phone number. For 1 person on the list the pivot table has added an additional 2 to the end of the phone number.

I have checked the original spreadsheet, the consolidated sheet and neither of thiose has the extra digit in it only shows on the pivot table.

The pivot table is set up with tabular layout so you get 1 line per person who meets the filters set to class start date and venue and i have checked that the column on the pivot table is formated the same all the way down.

Does anyone have an idea how the extra digit arrived and how i get rid of it? I have over trypwed the original data on the colsolidated list with some thing differnt and refreshed and then put the content back to the refernce cell and the extra 2 re appears - all very confusing
 

A:Solved: Excel 2007/2010 Pivot Table data error

Very hard to trouble shoot this on written notes. To find this... I would try moving/adding the person to another class. I would also try pivoting on class members and see how this entry appears. If still an issue I would make this thing with only the offending records and associated records. Excel usually doesn't make this stuff up.

In reality I would send this off and call it done!
 

Read other 3 answers
RELEVANCY SCORE 61.6

We have an upgrade on our computer units here in the company, my problem is when users save their 2007 excel files an error pops up, Errors were detected while saving "File Name". Microsoft maybe able to save the file by removing or repairing some features. To make the repairs in new file, click Continue. To cancel saving the file, click Cancel.

By the way, the files were save on the file server and users access them through single roaming profile that we created with full access on their folders.
i am hoping i could find an answer.

thank you

A:Error on saving MS Office Excel 2007 files to MS Office 2013

i have many views, but no reply... i am starting to think this forum is not helping me !...

Read other 2 answers
RELEVANCY SCORE 61.2

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

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

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

Many thanks.

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

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

Read other 1 answers
RELEVANCY SCORE 54.8

The ?problem? I?m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb.
I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit.The W700 has Office 2007 and theW541 has Office 2013.Both versions ofExcel are 32 bit as far as I can tell.
Until recently I was primarily using the W700ds but have nowswitched to the W541.


after I saw a larger file losing KB when saved, I did a test with a file that had not been altered or openedfor over two years. I copied it twiceand added a -1 and a -2 to change the names.The file was a small 832 Kb file.When I opened and saved on the W541 running Windows 7 with Excel 2013,the file saves with 771 Kb.When Iopened the file using the W700 running Windows 7 with Excel 2007, the computeron which it had originally been created, the file saved as 830 Kb.Both saved smaller but the newer computerrunning Excel 2013 was much smaller.Iam seeing these same types of ratios of reduction in size for much larger Excelfiles as well.

I have not documented any actual problems or loss of data withany of the files to date and I have used an Ultra-Compare text file comparison which found no differences.
Is there any reason to be concerned about this? And, if so, what to do?

As with many people, some of my files are the result of manyyears of work and I don't want to do anything to compromise any of the data butI don?t know whether or not what I?m seeing is normal due to both Excel 2007and Exce... Read more

Read other answers
RELEVANCY SCORE 54

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

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

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

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

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

Read other 16 answers
RELEVANCY SCORE 54

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

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

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

A:Solved: Excel search does not work Excel 2013

Read other 7 answers
RELEVANCY SCORE 53.2

Hi All,
I would like to know is there is any way i can Integrate of Access 2007 , Sharepoint 2010 and Info Path 2010, because as far as my knowledge we can upload Access 2007 into Sharepoint 2010. In Sharepoint i cannot able to use Access 2007 forms so i need to create another good looking way of showing the access lists.
Can you please anyone help me how i can implement this and if we can what are the requirements need to be done, like tools required and steps for the implementation.
If anyone can suggest some books also i can able to read it and learn it myself.
All the response are welcome and thanks for all your support.
 

A:Integration of Access 2007 , Sharepoint 2010 and Info Path 2010

I see no one is offering anything on this post. Not a great site for SharePoint(SP) information. But SP its self is relatively new for developers. We can't afford real SP developers so se make our own. Not a great plan but we are supporting a large SP site.

I think with Access 2007 the best approach is to use it to update list and make reports from list. There is no integration to InfoPath forms that I know of. You have to build them on top of your list with SP Designer.

I did find this video in my favorites that says publish access 2007 to SP2010. I haven't whatch recently...
YouTube
If you really need Access (in SP) you have to go to 2010. I waited till Access and SP 2010 were available on a test site and build a relatively simple db with a couple of reports and queries that did funcion correctly (without too much alteration). I did have to key each table before it would 'publish'. The 'publish' wizard will walk you thru needed fixes. I looked for the DB to refresh my memory but someone has rebuilt the test site and dropped it.

Any way good luck. I wish I had some recent experience on the issue to offer. Maybe this will 'bump' your thread and get some more information!
 

Read other 1 answers
RELEVANCY SCORE 51.6

Windows 7 Dell Multimedia computer.
It has Office 2007 installed , which includes PowerPoint 2007.

We need to upgrade PP 2007 to PP 2010 to help run embedded You Tube videos.

I have an unused and unopened stand alone version of PowerPoint 2010 to install on The Dell Multimedia computer.

How is the best way to do this upgrade with the least amount of problems ??

Can I uninstall only the PP app of Office 2007?
What if I uninstall the 2007, and then have problems installing the 2010?

Thanks in advance.
 

Read other answers
RELEVANCY SCORE 51.6

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

Read other answers
RELEVANCY SCORE 51.6

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

Read other answers
RELEVANCY SCORE 51.6

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

A:Office 2010 or 2013

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

Including these questions:

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

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

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

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

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

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

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

I'd worry most about the licensing details.

Read other 9 answers
RELEVANCY SCORE 51.6

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

A:MS Office 2010 and 2013???

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

Read other 2 answers
RELEVANCY SCORE 51.2

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

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

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

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

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

Read other answers
RELEVANCY SCORE 50.8

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

A:2010 Outllook and Sage ACT 2013

Read other 16 answers
RELEVANCY SCORE 50.4

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

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

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

Read other answers
RELEVANCY SCORE 50.4

Hey Guys,

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

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

These websites may help you.

PowerPoint 2013 not Displaying Inserted Photos - Microsoft Community

Powerpoint 2013 problem

Read other 7 answers
RELEVANCY SCORE 50.4

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

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

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

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

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

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

Thanks!

A:Office 2010 Pro compatible with Project 2013

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

Read other 9 answers
RELEVANCY SCORE 50.4

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

Read other answers
RELEVANCY SCORE 50.4

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

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

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

Read other 2 answers
RELEVANCY SCORE 50.4

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

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

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

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

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

Have you seen this:

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

Read other 6 answers
RELEVANCY SCORE 50

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

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

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

Thank you in advance fo... Read more

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

Read other 6 answers
RELEVANCY SCORE 50

We recently migrated from Office 2003 to Office 2010.

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

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

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

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

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

Read other 14 answers
RELEVANCY SCORE 50

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

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

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

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

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

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

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

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

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

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

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

Read other 16 answers
RELEVANCY SCORE 50

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

I hope somebody can help
 

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

Read other 6 answers
RELEVANCY SCORE 50

I have an Excel workbook in which I keep racing records. The data goes back about 5 years and as i have accumulated several hundred thousand records, I have moved much of the historical data onto separate sheets in the workbook so that values for calcs that rely on the historical data can be auto updated.

For current data I use a separare sheet as i was finding that it was takin g a long time to perform calcs when all the data (up to 200,000 rows) was all on the 1 sheet.

I wanted to know if it was possible to convert what i have to Access as it has been suggested that a database would do a better job of handling so much data, rather than Excel. I have moderate knowledge of Excel and have been able to build up the series of formulas for calculations in Excel over the years and have it pretty well doing all the things i want now but I have very little knowledge of Access design so not sure if I can convert and how to do it.

The Excel workbook contains a lot of formula that do calcs on past results and then use those calcs to do predeictive calcs for upcoming races. Because it was very "maths"based to start with, I started off using Excel and it has all grown from there. Is it possible to convert what I have to Access? Is is reasonably able to be done (by a moderate user like me with some expert help)?.
The files i have are too big to attach here, but would be happy to prepare some sheets without much data to show what i am doing and get advice.
 

A:Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007

Read other 13 answers
RELEVANCY SCORE 50

Have been trying to follow suggestions from similar posts, but nothing working. Have tried to save as .xls and .csv, as well as trying to 'define names' of the various columns, but nothing allows me to import complete contact into Outlook. Please help, very important to get these contacts into Outlook asap. Thank you
 

A:Issues importing large contact list in Excel 2007 to Outlook 2007

Hi hbsurfer

Try going about it backwards.
Create one Contact in Outlook 2007, then Export that one Contact to a .csv file.
Then you will be able to see the format Outlook 2007 is using and reconfigure your headers in the Excel spreadsheet.
When all headers match, you should be able to Import it. Or copy the excel information to the one contact .csv file and Import that.

Let us know if that works for you or not.
 

Read other 1 answers
RELEVANCY SCORE 50

I'm trying to run an Excel 2007 macro from Access 2007, when I get to the point where I want the macro stored in the active workbook I'm getting the following run-time error: run-time error '91' object variable or with block variable not set . It won't run the macro at all. I would greatly appreciate it if someone could help me fix my code so the macro will run. The code is listed below; step 10 is where I get the error.
Code:
Option Compare Database
Sub GetJournal_Entry_Data_transfer_to_Excel()
'Step 1: Declare your Variables
Dim MyConnect As String
Dim MyRecordset As ADODB.Recordset
Dim MyQueryDef As DAO.QueryDef
Dim MyDatabase As DAO.Database
Dim MySQL As String
Dim MyRange As String
Dim s As String


Dim Db As Database
Dim xl As Excel.Application
Set xl = CreateObject("Excel.Application")
Dim xlwkbk As Excel.Workbook
'Dim xlworkbk As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As Integer


'Step 2:Declare your connection string
MyConnect = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info = False;Data Source= P:\FINANCE\Balance Sheet\Inventory\Project TAN\Project TAN.accdb; User ID = Admin;"

'Step 3: Build Your SQL Statement
MySQL = "Select* From [mtb-TantasticJE's]Where [mtb-TantasticJE's].[Dscrptn_Text]='Culls_Stat34'and [mtb-TantasticJE's].[Co_Code]='1381'"

'Step 4: Instantiate and specify your recordset
... Read more

A:Access 2007 VB code to run Excel 2007 macro in active sheet

Read other 7 answers
RELEVANCY SCORE 50

My employer just upgraded to Microsoft Office 2007. According to the help files, I should be able to paste Excel charts into Word that update automatically when changes are made to either version.

I am clicking "Link to Excel data" and "Keep source formatting" when using the little popup clipboard to paste a chart into Word. But after closing both files, opening Excel and updating data on the chart, saving and closing Excel and re-opening Word, the chart is not updating with the new information. I can't get it to update by clicking on "refresh data" either.

Does anyone know how this is supposed to work? I was looking forward to being able to update just the Excel file and having it update in all the Word documents where it is pasted.

Our OS is Windows XP Professional, Version 2002, Service Pack 2. My work computer has a Pentium 4, 3 GHz processor and 2 GB of RAM.
 

Read other answers
RELEVANCY SCORE 50

Hi guys,

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

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

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

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

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

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

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

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

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

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

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

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

Read other answers
RELEVANCY SCORE 50

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

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

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

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

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

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

Read other 1 answers
RELEVANCY SCORE 49.6

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

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

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

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

Read other answers
RELEVANCY SCORE 49.6

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

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

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

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

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

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

Read other 6 answers
RELEVANCY SCORE 49.6

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

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

A:Microsoft Office 2010 to 2013 upgrade offer.

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

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

Read other 16 answers
RELEVANCY SCORE 49.6

Hello,

I have upgraded to Office 2007 from Office 2003. When I open an Excel attachment from email in Outlook 2007, the Excel application opens but the document itself does not. The document has a .xlsx extension. I need help resolving this issue please. If anyone knows why this is happening or the fix, I'd appreciate your insight.

JayT908
 

Read other answers
RELEVANCY SCORE 49.6

I'm trying to get the results of Access queries to be linked to an Excel workbook. I've been using the Data tab in Excel, clicking the "From Access" button in the upper left, and choosing the Access database. Then it asks what query I want to link.

The problem arises when I try to link a specific query, which we'll call qry_x. This query is based on several other queries, one of which is qry_z. Frustratingly, when I try to link qry_x to the Excel workbook, I get an error message that says that Access can't find qry_z, and suggests maybe I spelled the name incorrectly.

However, qry_z definitely exists as part of the database, and when I run qry_x (which is based on qry_z) in Access, the correct results are displayed with no error.

Note: qry_x is the only query this is happening to. I can link any other query with no problem at all, including qry_z!!!

What could be going wrong?

Thanks in advance.
 

A:Solved: Access 2007 / Excel 2007 - Linking to a database

Read other 16 answers
RELEVANCY SCORE 49.6

Hello,

I am having difficulty linking Excel data from a simple worksheet table to a table in Word 2007. I would like to retain all the formatting currently used in the Word table, but can't get the Paste Options working at all despite following all the advice on the Microsoft Knowledge Base.

If I copy the Excel data and then place my cursor at the first cell location within the Word table where I want the information to be pasted I get different paste options compared to placing my cursor outside of the table.

I am using the "Medium Grid 3 - Accent 3" Table Style in Word.

I have attached a couple of simple files to demonstrate the formatting and content in both apps.
'
Step by step help would be appreciated.

Thanks!
 

A:Paste link from Excel 2007 to Word 2007 table

Thought I would try one more time to get this one resolved. Is what I am asking not possible to do?

Cheers!

wmorotn01
 

Read other 2 answers