Computer Support Forum

Simple Program in Office Excel 2007

Question: Simple Program in Office Excel 2007

Data: Characters assigned by numbers (e.g. MARKETINGS assigned as M=0, A=1, R=2 & so up to 9).Input: CharactersCondition: Apply to Input CharactersOutput Should be: Some of the number for the input characters.

Relevance 100%
Preferred Solution: Simple Program in Office Excel 2007

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

Answer: Simple Program in Office Excel 2007

Post: Lacks any request for help.

8 more replies
Relevance 69.7%

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

Answer: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 !...

2 more replies
Relevance 69.29%

I have an Excel file which has some moving objects as well as some drop down menus. I recently installed MS Office 2007 after erasing 2003. The Excel tables now are disabled, the file now looks like a picture, only the fields outside of the content are really clickable.I have tried to enable all macros, downloaded the MS compatibility pack, still same issue. Any suggestions/ideas? The file works in 2013 and 2016.I can share the file upon request ...

Answer:Office 2003 Excel file will not open with Office 2007

Thank you for your suggestions, here an update: I got the file working - how, no idea. I re-opened the original attachment, deleted the one I had on my PC and voila, it works.

9 more replies
Relevance 68.47%

I'm trying to use column A as a 'sequence' number (1, 2, 3, 4, 5, ...) in a spreadsheet, so I enter '1' in cell A1 and enter the simple formula =A1+1 in cell A2 (which correctly returns the number 2). But, when I copy the simple formula in cell A2 and paste it into cell A3, the value in the cell is 2 even tho the formula shows as =A2+1. This works just fine in Excel 97 and 2003, so what am I doing wrong?

Thx for any advice you can give.
 

Answer:Excel 2007 - Pasting a simple formula issue

I've just tested this out on Excel 2007 and it works fine on my PC. I'm at a total loss as to why it would add 1+2 and make 2?
 

6 more replies
Relevance 68.47%

I use MS office 2007 daily, but today I cannot access it properly. I attempted to open a file by clicking on the "office button" and it immediatly closed everything. I tried to save from the office button and each time I click on the office button it closes everything out. I just discovered other things are affected as well. I cannot access any drop down items on anything. So it is not just an Office thing.

Answer:MS office 2007 office button immediatly closes program??

Try running the System File Checker:http://support.microsoft.com/kb/929833

6 more replies
Relevance 68.06%

I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells.
I have cleared the cells formatted the number but it still keeps on rounding up 25799 to 258. I downloaded a stack of MS Office updates 3 days ago, is it possible one of these Updates has corrupted - broken my Excel program?

I am considering uninstalling all of those updates and turning off Updates for MS Office altogether.

Answer:Excel 2007 (MS Office 2007 enterprise)

Hi there.

To test if it's really a software issue, please try out on a new excel spreadsheet and see if the problem is still there. It might not necessarily be the software. Once we have confirmation that the problem exist on a fresh new spreadsheet, then try to do a repair first before uninstalling.

7 more replies
Relevance 68.06%

Hi All,

I really hope someone can help me. I've been looking through all the forums and haven't quite found a macro code that has worked for me. I know this is very simple, but I have no idea what I am doing. Here it goes....

I have a very simple expense report on Sheet 1 of an Excel (2007) workbook. In this worksheet, the first couple of columns simply list the expense items. However, there is a table with only 14 rows (including the header) of data (6-19). Underneath row 19 is a total row that sums the 2 columns of information (don't need to worry about this row but thought I'd tell you anyway). This table only has 4 columns as follows:

Column G - Code
Column H - Category
Column I - $ (this column is using the SUMIF function to calculate the expense category totals)
Column J - % of Total (this column is simply dividing column I by the Total $)

I don't know if this matters or not but there is also a pie chart linked to this table of information.

I would like this table (H6:J19) to automatically sort by % of Total (in descending order) any time I add new expenses so that I don't always have to sort manually.
If there is a way to do this, I would so appreciate simple instructions. I've attached a sample of what the report looks like.
I hope you guys can help!!!
 

Answer:MACRO NOVICE - Simple Auto Sort using Excel 2007

Hi Janel, welcom to the board

I think this should do the trick, I don't have 2007 here but I used your sheet in 2003

Add the following code the the Sheet1 project

Code:


Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.Range("G7:J19").Sort Key1:=Range("J7"), Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

To do this just right-click on the Sheet1 tab and select view Code, you will automatically be in the VBAProject.

In the right screen paste the code above.

every time you change values in the list the range G7:J19 without hearders will be sorted by Total % descending order, th epoie chart will do it's own work since it's related to this table.

Happy coding.
 

1 more replies
Relevance 64.78%

I'm try to resolve the following:-
Firstly in cell A4 is equation A4 =sum(A1-A3) ie taking one number from another to give a total.
What I'm trying to do in the cell A4 is to compare this value with another cell say B4 and if A4 is higher to make that cell turn RED and if lower turn that cell GREEN.
if number in cell A4 is great than B4 number is shown in RED or lower shown in GREEN

Answer:excel office 2007 help

You want conditional formatting Conditonal formatting and How to use

8 more replies
Relevance 64.37%

Hi-

I have a user we recently upgraded from Office 2003 to Office 2007. Recently she has been experiencing intermittent crashes with her Excel 2007. It usually happens when she is opening a document, the system will say it will run into an error and then shuts down. It starts trying to recover her documents but just freezes until I cancel that command. Once that command is cancelled, the program opens up again and shows all of the documents that she can recover. The below is the error message. Any ideas on a fix?

Event Type: Error
Event Source: Microsoft Office 12
Event Category: None
Event ID: 1000
Date: 8/1/2007
Time: 9:13:26 AM
User: N/A
Computer: L-0007
Description:
Faulting application excel.exe, version 12.0.6024.5000, stamp 465f21c3, faulting module excel.exe, version 12.0.6024.5000, stamp 465f21c3, debug? 0, fault address 0x001d70b6.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 65 00 78 00 63 00 .e.x.c.
0030: 65 00 6c 00 2e 00 65 00 e.l...e.
0038: 78 00 65 00 20 00 31 00 x.e. .1.
0040: 32 00 2e 00 30 00 2e 00 2...0...
0048: 36 00 30 00 32 00 34 00 6.0.2.4.
0050: 2e 00 35 00 30 00 30 00 ..5.0.0.
0058: 30 00 20 00 34 00 36 00 0. .4.6.
0060: 35 00 66 00 32 00 31 00 5.f.2.1.
0068: 63 00 33 00 20 00 69 00 c.3. ... Read more

Answer:Office 2007 Excel crash

Event Type: Error
Event Source: Microsoft Office 12 Sessions
Event Category: None
Event ID: 7001
Date: 8/1/2007
Time: 9:13:22 AM
User: N/A
Computer: L-0007
Description:
ID: 1, Application Name: Microsoft Office Excel, Application Version: 12.0.6024.5000, Microsoft Office Version: 12.0.4518.1014. This session lasted 6231 seconds with 1260 seconds of active time. This session ended with a crash.
 

1 more replies
Relevance 64.37%

PLEASE, Help Me To Get Right Formula For Excel SheetSHEET:Uploaded with ImageShack.usPROBLEM:IF A2+90 IS MORE THAN 1500 THEN B2=1 IF A2+90+90 IS MORE THAN 1500 THEN C2=1 BUT IF B2=1 THEN C2=0 IF A2+90+90+90 IS MORE THAN 1500 THEN D2=1 BUT IF C2=1 THEN D2=0 IF A2+90+90+90+90 IS MORE THAN 1500 THEN E2=1 BUT IF D2=1 THEN E2=0....AND SO ONPLEASE HELP!

Answer:MS OFFICE 2007 EXCEL "IF" FUNCTION

It could end up being fairly lengthy but try nested IF functions used with AND

Something like

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

http://www.techonthenet.com/excel/formulas/if_nested.php has a good example at the bottom.

14 more replies
Relevance 64.37%

I have intalled Office 2007 and when trying to use Word and Excel I get "Not Respoinding".
I am using Vista and did not see an answer or possibly overlooked an answer since I am new and trying out my new wings with you. It is so frustrating. Please help.
ingemartin

Answer:Office 2007 Word and Excel

First I would recommend reinstalling the Office Suite all together and downloading any updates that go with it. If that doesn't work, I would start looking at which programs you have that have built in Office Add-ons. Some of these add-on capabilities have been known to cause massive slowdowns in Office performance.

2 more replies
Relevance 64.37%

I'm using Windows XP, Microsoft Office 2007 Professional. When I highlight a column, the highlighted color is so light that when I do a "Find" (Control F) command and it finds the value you can't tell it found the value. (The found value is in white which isn't much different than the highlighted column.) Is there any way I can darken the highlighted column? I've tried changing the color scheme for the entire program and that doesn't help.
 

Answer:Microsoft Office 2007 Excel

8 more replies
Relevance 63.55%

Hello
In the document library if I click on an word document the document opens in word.
If I click on an excel document it opens in notepad.
If I open Excel and drill down to the libary document excel file the document will open in Excel.
I looked at the document library excel files and noticed that the excel files were associated with notepad.
I then went to 'open with' and located on the desktop Excel.
However when I click on the document library excel file I get 'not a valid win32 app...'
What Excel is linking / associating with / opening with is Excel Component - and not the Excel Application.
Evidently I associated "open with" the Excel Componet - and I simply cannot find the Office 2007 -Excel Application when I browse through for example 'ProgramData' 'Program Files' and so forth.
Where can I find Excel.exe so that I can use the 'open with' ?

Answer:Office 2007 Excel File Association

The exe file you are looking for should be: C:\Program Files\Microsoft Office\Office12\Excel.exe

1 more replies
Relevance 63.55%

I have two tabs in my workbook, a master tab (sheet 1) and a deployment tab (sheet 2). The master tab lists all stores with all of their related data. The deployment tab lists only the stores that have had something done to them. Both tabs have the store number listed in column A.
In column B in the master tab, I want it to look at the deployment tab and if there is a match, put a Y and if not a N (or yes/no... whatever). Please help! I can not find the formula.
Thank you,
Charlotte
 

More replies
Relevance 63.55%

we have microsoft office excel 2007 installed on our computer, however we like the older version 2003 better. are we able to load both on the same system? or do we have remove the 2007 to install 2003?

Answer:office excel 2007 & 2003 on same computer?

Originally Posted by jnielsen11


we have microsoft office excel 2007 installed on our computer, however we like the older version 2003 better. are we able to load both on the same system? or do we have remove the 2007 to install 2003?



For earlier versions of Office products, MSFT published a number of KB articles that describe the issue of having more than 1 version of Office in OS, andthey did list some significant potential problems.

Some of the articles were KB 292491, 218081, 828956 and 290576.

In any case, you would really have to uninstall 2007 before installing 2003.

5 more replies
Relevance 63.55%

Hi All, hoping someone can give me a quick answer to this.
Bosses PC..Excel files will open, he can change items in the boxes, but cannot save them. He cannot print, alter, print preview, in fact he cant do anything with them bar open them. Ive sent the files to my PC and they are perfectly ok. IE i can work with them.
Any suggestions to this as he cannot open a file and then go into settings to change anything.
Need a quick answer as he`s a load of work on that needs to be sent back out this morning.
Thanks
John

Answer:office Professional 2007 Excel problem

Would i be better trying to reinstall or repair office 2007 ?

3 more replies
Relevance 63.55%

I have a 32 gig flash drive on which is an MS Excel 2007 file with all my passwords, serial numbers etc.

Last week I purchased a new HDD and successfully installed Vista Home and MS Office 2007 but when I click on the Password File on the flash drive, I get a message that "Excel cannot open the file .............. .xlsx due the file format or extension being invalid. Verify that the file has not been corrupted and that file extension matches that of the file format.

I have tried opening it in MS Word and other similar programs but no joy.

I downloaded the MS Compatability Pack but nothing................

Any ideas on how I can get this important file to open properly using Excel?

Virtually nothing has chaged to my way of thinking except the reinstallation of Excel again!!
 

Answer:Cannot open MS Office 2007 Excel file

It doesn't help, I know, but if you manage a successful recovery, I'd suggest saving what is a crucial file in text form. "Ah, you fool!" I hear you say. "Text files can be read by anyone. Why would I keep my passwords etc. in a text file?!?" To that, my response would be ADS. Look it up.
 

3 more replies
Relevance 63.55%

I'm probably missing something obvious, but I can't seem to find an "always on top" setting for viewing a spreadsheet. Any help appreciated
 

Answer:Solved: Office 2007 Excel - Always On Top Option?

8 more replies
Relevance 63.55%

We recently purchased a new Lenovo P51 Thinkpad with Windows 10.  Rather than spend $400 for an upgraded MS Office Professional, we transferred Office Pro 2007 from the old laptop to the new laptop.   However, we have encountered two problems: When one tries to copy a large block of text from a website into Word, Word will display an error message that it has stopped working.  A window appears that shows a progress bar and states "Microsoft Office Word is restarting."  This also appears if we try to click on the ?Proprerties? menu items.    Word then shuts down and displays all open documents as retrieved autosave files. Then after Word restarts, we try to save one of the eight reopened documents and get this error message: Save As           c:\Users\[name]\Documents\[subfolder]\[file name].docx           You don't have permission to save to this location.            Contact the administrator to obtain permission.            Would you like to save in the Documents folder instead?    Yes   No Ultimately, it is not possible to save the file on the hard drive.  It will only save to a flash drive.This problem only occurs with Word and Excel and not with Publisher or Power Point. Any ideas how to fix this?   Will uninstalling MS Office Pro 2007 a... Read more

More replies
Relevance 63.55%

G'day all,
I recently went from XP to Vista which has Office Excel 2007. The problem is that I saved spreadsheets from excel 2003 that saved as XLR files. The 2007 excel is supposed to open these files but it won't . There seems to be plenty of information on reading 2007 files with 2003 programs but not the reverse. Can I open them in a computer that has excel 2003 and save or convert the files to xlsx?
Hope someone can help, old dog.
 

Answer:Office Excel 2007 won't open xlr files

This looks like what you need.
http://www.online-tech-tips.com/ms-office-tips/bulk-convert-office-2003-to-2007/

If that appears too scary, google docs will open your excel 2003 spreadsheets. I'm not sure if you can convert them.
Also Open Office v3 supports both older office and newer office file types. http://www.openoffice.org/
 

2 more replies
Relevance 63.55%

Hi all,
help needed please for a excel formula for the following problem.
In my daughter in laws work she as to occasionally alter the the price of a lot of the goods they supply by 1 or 2 percent. The problem is that the manager/owner does not want the price to be exactly a round figure eg £1:00 it can be £0:95 or £1:05 in divisions of 5p So she is in need of a excel formula to round up/down the price to the nearest 5p omitting the .00 Can this be done?

Answer:Microsoft office 2007 excel formula

tonyq
Not sure if this will work in 2007, I use 2010. There are two functions 'ceiling' & 'floor' that you can use.
EG: - Cell A1 has original price (£1 for example)
Cell A2 =b1*98/100 (a reduction of 2% so £0.98p)
Cell A3 = Ceiling(A2,0.05) will go to the nearest 5p above £0.98p (£1) or
Cell A3 = Floor(A2,0.05) will go to the nearest 5p below £0.98p (£0.95p).
Cells need to be formatted for currency.
Hope that helps

10 more replies
Relevance 63.55%

I have MS Office 2007, Windows 7. When I double click on an xls file Excel opens up but it is just a empty excel program. It is similar to opening up excel and then just closing the book1 that opens up automatically. Just a grey background. Also I can't open up xls files by doing File > Open or dragging xls files into an already opened excel. And double clicking an xls does not work. I tried doing a detect and repair on excel but that did not seem to fix anything. Any ideas? Thanks!

Answer:MS Office 2007 Excel files not opening

Try this fix posted by JoshHiggins Monday, June 06, 2011 8:28 PM click here

had the same issue here and was able to fix without creating new user
profiles. In my case, I deleted the Excel registry keys for the user
under: HKEYCURRENTUSER\Software\Microsoft\Office\14.0\Excel <--
Close all Excel windows and delete this entire folder. The workbook
opens OK after this.

2 more replies
Relevance 63.55%

Hello everyone,

I have two questions regarding Microsoft Office Excel 2007, that are no doubt simple ones to answer.

Firstly, is it possible to have a column where every entry added would appear automatically with quotation marks? For example, if I entered Movie #1 in to a cell in Column A, when I click out of that cell, can it automatically change it to "Movie #1"?

Secondly, on a seperate work-sheet (but within the same work-book), how can I have a display telling me how many cells appear in a particular column on another work-sheet? For example, if I have Column A in Work-Sheet #2 filled with entries, can I have a cell in Work-Sheet #1 tell me how many entries there are there in total?

I hope that all makes sense.

Any help would be appreciated!
 

Answer:Solved: How Do I Get Microsoft Office Excel 2007 To Do This...?

7 more replies
Relevance 63.55%

I have two users that are having problems with saving excel 2007 files on a storage server. One will save a file and the next time she opens it and makes changes it will not let her save as an xlsx file. The server shows a ~$file and cannot be deleted. It looks like it is not closing the tmp file and the next time she opens it the it thinks the file is opened by someone else.

Any clues.
Thanks,
Bill;
 

Answer:Solved: Office Excel 2007 Problems

11 more replies
Relevance 63.55%

Greetings!

I have a macro in Excel to filter out rows with zeros. That works good. I want to change the "0" to a text string "(A1)". How do you do that? I tried putting both double and single quotes and it wouldn't work.

TIA for your ideas!

---------------------------------------------------
Option Explicit

Sub HideZeros()
Selection.AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd End Sub

Sub ShowZeros()
Selection.AutoFilter Field:=1
End Sub
 

Answer:Office 2007 Excel Macro has me stumped...

Try something like this....
Code:


Selection.AutoFilter Field:=1, Criteria1:="=[I]TextGoesHere[/I]", Operator:=xlAnd

 

2 more replies
Relevance 63.55%

i have office 2007 in my xp os & i am unable to open excel file but able to other word, powerpoint,paint,outlook applicatios.

Answer:office 2007 excel file is not open

What happens when you try to open them?

1 more replies
Relevance 63.55%

at my work we have 4 computers running MO-03 and 2 using MO-07 trial. we use excel quite a bit with imported images (.jgp and .png) in the worksheets. when a file is created in 07 it seems that the images don't compress down very much (double clicking the image and selecting the compress button in the general tab) and when printing and opening these files on a computer using 03 the images have moved from where they were first placed on the page. in addition the images are able to be compressed quite a bit then in 03, there have been files that are over 1MB that compress down to 600-700 kb. note that this is all while saving as .xls (not the new format, i don't recall the extension right not) files, i have changed the default save as such.

has anyone experienced this? i have searched on the internet to find solutions or answers of why it would behave differently but have not found any.
 

More replies
Relevance 63.55%

Not sure where to post this, but in the last month Office Word & Excel 2007 have slowed down and progressed to "not responding". Cut & paste are virtually "cut and wait 5 minutes" and maybe it will appear properly.

I have check for viruses with Malwarebytes and AVG and have used Spybot, also. I have also ran MS Diagnostics. Everything seems to be in order.

I am using Vista Home Premium with Service Pack 2.

I know this problem has been ongoing for several years, but this is first time I've had to deal with it and MS Support is as usual not helpful.

Would appreciate someone else's clear mind as mine as become muddled trying to remedy the problem.

More replies
Relevance 62.73%

I recently purchased a new computer and transferred my files from the old one. Both systems run Windows 7 with the same version of Office (2007). After the transfer, Excel files will only open when accessed from Excel - otherwise, they try to open in Word. If I click on a file and select "open with," the only option is to open with Word. Any ideas?
 

Answer:Office 2007 Excel files opening in Word

Try clicking on the Win7 Orb and selecting "Default Programs" and select "Associate a file type or protocol with a program". Scroll down to .xls and change the program that it opens with to Excel by highlighting it and clicking on the Change Program button in the right hand corner. You will recognise other Excel extensions in the same area which you might want to change in the same way.
 

1 more replies
Relevance 62.73%

i have a rdp server and have installed office 2007. its been fine for many years. but then the other day users kept saying when they opened excel it opens only in safe mode. iv check my connection and it does not do this. anyone got any ideas
 

Answer:office 2007 excel opens in safe mode

Could be caused by an Excel Add-in. You might want to use the Office Button->Excel
Options->Add-ins and start disabling add-ins one at a time to figure out if
one of the active Add-ins is causing the problem.

You can also open
C:\Documents and Settiing\"Your profile/logon name"\Applications\Microsoft\
and look for the Excel folder. The Excel Folder will have a
subfolder called XLSTART, if there are any files in that folder, delete them.
 

2 more replies
Relevance 62.73%

I am creating a worksheet about financial repayments, where the repayments are irregular.

Say for example the total repayment is £1000 and I put this in cell D1 ( alongside other headers). I am putting the repayments in column C, so the first entry would be in cell C2.

What I want to know is whether or not there is a very (I mean VERY) simple way to format column D so that any entry in cloumn C will be automatically subtracted from the first figure of £1000 and subsequent running totals and if so will I also be able to format column D as a £ figure (I know how to do that but not with any other formatting)

Yes, I know I sound very lazy (I am), but my maths are poor and it will be a long list, so if I make just one error it will be a load of hassle.

I would be obliged for any assistance.

Thank you
 

More replies
Relevance 62.73%

I'm typing up a lab report, and usually in the past I never had a problem with this. I have two graphs on there, and each one contains thousands of points. These graphs are REALLY slowing down Word. I'm getting lagged typing, and overall it feels like I'm using an ancient PC. Is there any way to flatten these images. I know saving as 97-2003 doc does this, but all of my equations blur, and everything just doesn't look good. I end up converting to PDF instead of 97-2003 format and printing that.

So other than just removing the graphs for the time being, or taking a screenshot, cropping and pasting back in, is there anyway to flatten these so they just turn into an image?

Thanks.
 

Answer:Flatten Excel Graph in Word? (Office 2007)

probably because pasting the graphs from Excel to word embeds an excel object into word (thus you can edit inside of word)

if you go edit->paste-special (instead of just paste) you can choose to paste as an image instead
 

1 more replies
Relevance 62.73%

When I try to launch Excel or Word I get the screen: "Please wait while Office prepares the necessary files". I then have to wait for the procedure to be completed.
In addition, on launching Excel I get a box showing stdole32.tlb.
I have tried to replace that file with a copy but, in spite of logging in as Administrator, it won't copy and replace.
I have carried out a Repair of Office 2007 but it makes no difference.
Help would be appreciated.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Pentium(R) Dual-Core CPU E5300 @ 2.60GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 4060 Mb
Graphics Card: Intel(R) G41 Express Chipset, 1806 Mb
Hard Drives: C: Total - 461899 MB, Free - 164566 MB;
Motherboard: Dell Inc., 0J190T
Antivirus: avast! Antivirus, Updated and Enabled
Office 2007 Enterprise Edition
 

Answer:Problem Opening Excel and Word in Office 2007

10 more replies
Relevance 62.73%

This is a question about the search functions within Microsoft Office Word 2007 and Excel 2007. I want to be able to do searches that would yield both &#8220;e&#8221; and &#8220;é&#8221; in the results of a single search. Right now all I can do is two separate searches.

My OS is Windows Vista. An example of what I'm looking for is a search that would bring up "cafe" and "café". It's probably either a way to ignore accent marks or a way to define searches for "e" as if they were searches for &#8220;e or é&#8221;.

Thanks very much for your help.
 

More replies
Relevance 62.73%

I have Office 2007 running on a Windows 7 64 bit Toshiba laptop. I am trying to separate the data and time in an Excel file in one column and put the date in one column and the time in another. I need a "how to" procedure to do that.

Answer:Separating date and time in Excel Office 2007

Excel has formatting for Date and Time.
For column A use a Date format, and for column B use a Time format.
To copy the value from column A to column B a function in column B like this should work
= IF(A1="","",A1)

5 more replies
Relevance 62.73%

Help needed please? I just installed Office 2007 over Office 2002 Running XP win PRO. the Macros in one main column in my workbook (the onlu Macros in that book) that was working perfectly 10 min ago won't work???
All the Dropdowns I installed are there with there Lists and working perfectly! But the one Column with VBA which is activated by these Dropdown's wont work since I installed 2007 and yes I have vallidated it etc! It is NOT a Pirated edition. Can somone help please Dasha
 

More replies
Relevance 62.73%

Hi,When I click on the Help button in both programs , this is what I get:CL Viewer can't display HelpCL Viewer cannot install the necessary files due to Window Installer error 2The system cannot find the file specifiedI have run the 2007 Diagnostics and it says it cannot find a problem.Is there perhaps a file I can activated that is somewhere in the Office 2007 main file?

Answer:Office 2007 -word And Excel "help" Files Missing

Hi billibo

I don't know if this is relevant, but I had a problem a couple of days ago and found that my Windows Installer Service had somehow been disabled. Resetting this to manual fixed things for me. Something to check anyway. (Control Panel>Administrative Tools>Services).

Good luck.

1 more replies
Relevance 62.73%

I'm having a frustrating problem that I'm guessing is going to be easily solved.
I have a user who opens word and excel files directly from a website and has a requirement to fill some details in and then send them via outlook 2007 to recipients.

Up until about a week ago this was no problem... within Word 2007, simply click on the send to mail recipient button and outlook opened and off it went.

After seemingly nothing has changed, Word now wants to open outlook express instead of Outlook 2007. (The default mail program is still Outlook 2007).

Does anyone know the cause of this.

Thanks
Ian.
 

Answer:Office 2007 using wrong Email Program

9 more replies
Relevance 62.73%

OK I think that this program change is dumb, anyway my school uninstalled word perfect 12 and installed office 2007. Is there a program that can open these projects i wrote on office 2007?

Answer:opening Office 2007 in a diff program

http://www.ehow.com/how_4898107_use-microsoft-word-wordperfect.html

9 more replies
Relevance 62.32%

I cannot access Excel files (MIcrosoft Office 2007) from shortcuts but can access the files from the application "file/open". This occurred recently and may be linked to a new update of Norton Internet Securty. The error message is unable to open 'filename'. Make sure you typed the name correctly and then try again. My OS IS Vista
 

Answer:Solved: Cannot access Excel files (Office 2007) from shortcuts

9 more replies
Relevance 62.32%

For some unknown reason, my office 2007 apps (Word, Excel, PPT) are beginning to crash when I close the applications.  This happened for all three products, below are the problem reports with no solutions yet.  It seems to be a driver issue but I have no idea where to start looking.  Please kindly enlighten.  Thanks very much. WORD: ProductMicrosoft Office WordProblemStopped workingDate10/6/2010 2:08 PMStatusNot ReportedProblem signatureFiles that help describe the problemExtra information about the problemLCID: 1033Brand: Office12Crashskulcid: 103315321840.cvr15321840.odVersion.txt15316224.odCVRB500.tmp.cvrAppCompat.txtmemory.hdmpminidump.mdmpProblem Event Name: APPCRASHApplication Name: WINWORD.EXEApplication Version: 12.0.6535.5000Application Timestamp: 4bbf7396Fault Module Name: ntdll.dllFault Module Version: 6.0.6002.18005Fault Module Timestamp: 49e03821Exception Code: c0000005Exception Offset: 0003e13dOS Version: 6.0.6002.2.2.0.256.6Locale ID: 18441EXCEL:ProductMicrosoft Office ExcelProblemStopped workingDate10/6/2010 8:39 AMStatusReport SentProblem signatureExtra information about the problemLCID: 1033Brand: Office12Crashskulcid: 1033Bucket ID: 1904063848Problem Event Name: APPCRASHApplication Name: EXCEL.EXEApplication Version: 12.0.6535.5002Application Timestamp: 4bd2a7f1Fault Module Name: OLEAUT32.dllFault Module Version: 6.0.6002.18005Fault Module Timestamp: 49e037daException Code: c0000005Exception Offset: 000046b0OS Version: 6.0.6002... Read more

More replies
Relevance 62.32%

Just recently when trying to format cells etc. after right clicking on the cell the context menu appears and disappears within a few moments. Sometimes there is sufficient time to navigate the menu but most often not. The problem is affecting the ribbon drop downs also and is present in Word. The others I haven't checked as I tend not to use them.
 
Tried re-booting and running in safe mode but this doesn't help. Tried a different compatibility mode and this works but is rather cumbersome and removes some functionality.
 
The problem only seems to exist in my profile. I've thought about creating a new profile but the thought of having to copy across all the necessary files rather puts me off.
 
I was wandering if anybody on here had a better suggestion or easier solution. If I have to create a new user profile I'd like it to have the same name as the original and also all of it's associated programs. Many thanks in advance.
 
Update: I've now installed MS Office Pro+ 2010 and the problem persists.

More replies
Relevance 62.32%

I have not had this trouble before but now I find I cannot print an Excel page consisting of names & addresses, phone numbers & email addresses. The page does in fact print out but is unusable because all the data is compacted into an area the size of a postage stamp. Can anyone help please?

Answer:Failure to print an Excel page (Microsoft Office 2007)

You could try print preview/page setup and make sure the correct paper size is selected and the scaling is set to 100% or fit to is set at 1 page(s) wide by 1 tall

1 more replies
Relevance 62.32%

I know I can do this as I have done it in the past a long time ago. Using the Find and Replace option add and extension to my sku numbers, such as:

SKU #

8686708052

I have a column of these sku's and want to add the extension .jpg to all of them at one time!

8686708052.jpg

I have done this in the past and can't remember what I did and it worked great instead of having to manually add the .jpg extension to every sku #!

Thanks!

Answer:Microsoft Office 2007 Excel Find and Replace Command

Might this be what you are looking for ...

[SOLVED] adding text to end of all cells in column

2 more replies
Relevance 62.32%

Hi all.

I recently upgraded our office to MS Office 2007 SP1 Pro plus.
I generally get people complain about how slow it is, but one issue that some users have got is that the toolbar/ribbon in Excel blanks out when switching between Outlook 2007 (via exchange server 2003) and Excel. Nothing else is open at the time.

The message pops up "Not enough system resources to display completely ".

I have had a look on the web and some have mentioned the size of the spreadsheet.
I was willing to pursue this line of thought, but this morning, someone got it without opening a spreadsheet. He had Outlook open, opened Excel, walked away then came back to the ribbon blanked out.

However, the user has an addin. I will get him to try and open Excel with the addin disabled.

The machines vary in specs, but this person has a brand new HP 2.4GHz Core 2 duo/2GB ram 150GB HDD. Another has a new HP laptop, and the same specs.

Can anyone shed some light on this?
 

Answer:Office 2007 - Excel - Not enough system resources to display completely

6 more replies
Relevance 62.32%

I am creating a worksheet about financial repayments, where the repayments are irregular.

Say for example the total repayment is £1000 and I put this in cell D1 ( alongside other headers). I am putting the repayments in column C, so the first entry would be in cell C2.

What I want to know is whether or not there is a very (I mean VERY) simple way* to format column D so that any entry in cloumn C will be automatically subtracted from the first figure of £1000 and subsequent running totals and if so will I also be able to format column D as a £ figure (I know how to do that but not with any other formatting)

Yes, I know I sound very lazy (I am), but my maths are poor and it will be a long list, so if I make just one error it will be a load of hassle.

I would be obliged for any assistance.

Thank you

* Particularly, I dont anything about macros or visual basic (but basic is what my knowledge is)
 

Answer:Solved: Microsoft Office Excel 2007- Automatic Subtraction

8 more replies
Relevance 62.32%

our group uses 2003 share point, i recently have upgraded from 2003 office to 2007 office

i find that synchrniztion feature is not there in 2007, i downloaded in installed add-in 2007 synchroniztion but i am still not getting option of "synchronize with Sharepoint" when i right click on table..

Does this even suppose to work? if yes could someone tell me solution or workaround please..
 

More replies
Relevance 61.91%

I have the full version of Microsoft Office 2003. My Microsoft Office 2007 has expired (the 6 month trial that came with my computer). Is there any reason I should not uninstal the 2007 version? I.e., would there be some documents that I would not be able to open in the older (2003) version of Office?

My main reason for wanting to delete Office 2007 is that when I attempt to open a file my computer tries to open it using Microsoft Office Picture Manager 2007. I am confident that I did not create these documents in the program, but rather in Word 2003. Will deleting Office 2007 solve this issue?

Thank you.
 

Answer:Microsoft Office 2007 - harmful to uninstall this program?

I don't think there should be any problem, you can uninstall it and see if there are any problems
If there is download a fresh trial or purchase the product.
 

2 more replies
Relevance 61.5%

I get the following message when I open Excel, Word and Powerpoint (Publisher works, but dare I try any others?)



Excel Failed to start correctly last time. Starting Excel in safe mode will help you correct or isolate a startup problem in order to successfully start the program. Some functionality may be disabled in this mode.

Do you want to start Excel in safe mode?




If I click yes or no it doesn't do anything, (on occasion Ill get a message prompting to diagnose and repair, a couple of minutes later it says i's successful but back to square one)

I have just installed SP1 in hopes there's some sort of fix, to no avail
I have tried a repair via the installation disc
I am hoping I don't have to uninstall / reinstall because I don't know if the licenses are limited

If anyone could shed some light on how to fix it, I would greatly appreciate it!


OS: Windows XP with SP3
Model: Compaq Presario V5000
Office: Microsoft Office Home And Student 2007
Specs: Pentium M 1.46Ghz CPU, 512MB RAM
 

Answer:Issues opening Excel, Word and Powerpoint - Microsoft Office 2007

A reinstall of Office 2007 will be the quickest fix.
 

19 more replies
Relevance 61.5%

I've got two different spreadsheets in Microsoft Office Excel 2007 that rely quite heavily on graphs. Now, the issue I'm having isn't stopping the practical functions of the spreadsheet, but it is aesthetically frustrating.

Each time I access either spreadsheet, some of my graphs data labels reset their formatting and styles. Approximately 75% of the data labels remain as they were originally formatted, but approximately 25% of them reformat themselves each time. I correct it by formatting them the way I'd prefer, and I re-save, but the next time I open the spreadsheet they've gone back to their default state.

Now, this is only the formatting, not the content of the data label, but it is still frustrating.

Can anyone please give some advise as to how I can fix this?
 

Answer:Graph Data Labels Resetting In Microsoft Office Excel 2007

Is anyone able to help me with this, please? It's such a frustrating issue.
 

1 more replies
Relevance 61.5%

I want to create a shortcut to run Excel from the command line and in that command or batch be able to run a macro from the workbook in my XLSTART folder. This way, the user does not have to run the macro from Excel menus.

I also want to create a shortcut to run Word from the command line or batch to run a macro (a global macro) when Word opens. Again, the user does not have to get inside Word to select a macro from the menus.

I have searched the internet and found that neither program has command line switches to immediately run a macro at the Office program start up.

Thanks
 

Answer:Solved: Run Excel and Word Macros From Command Line Office 2007

9 more replies
Relevance 61.5%

I have installed MS OFFICE 2007 in Win7 Home Premium 64bit. Every time I attempt to start excel or word it tries to do the configuration and terminates in an error. When I start excel it immediately brings up an information window that simply says stdole32.tlb, then goes into configuration and errors out. I have looked in the C:/Windows/System32 folder and the stdole32.tlb file is there. I would appreciate any help that can be offered. Thanks.
 

More replies
Relevance 61.5%

Hello Friends,

I faced a problem There was a problem sending the command to the program. I am using Office 2007
on Windows 7 Ultimate 64 bit. I have not faced this problem on 32 bit version of Windows 7 Ultimate.
The reason for writing this post is to help those like me trying out each of those "possible cause and probable solution" flooding many websites. Someone says to "uncheck the Ignore other applications that use Dynamic Data Exchange (DDE)", some point out 3rd party applications, some say to uninstalling some Hotfixes helped them, and guess what MS says ? It collected different success stories and sumarized it as case studies on : https://support.microsoft.com/en-in/kb/3001579
In my view, the problem existed because proper parameters weren't passed to excel.

The following is the actual solution (Backup registry 1st):
1. Open Regedit, go to the following location :
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
2. Right click on the (Default) value, click modify. You will find the path of EXCEL.exe & switch,
in my case it is "F:\Microsoft Office\Office12\EXCEL.EXE" /e. Change to:
"F:\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
If there are whitespaces in the path, then enclose the path within double quotes.
Also, the %1 should be within double quotes.
3. Right click on the command value, click modify. Just put a "%1" next to the /e at the end.
4. Go to the... Read more

More replies
Relevance 61.5%

My new computer came with Office 2007 Home and Student Edition. It has Word, Excel, etc. but does not have Outlook, which I need. Would it make sense to buy stand alone Outlook 2007 or should I buy a more comprehensive suite of Office itself?

If I decide to go with another email program, can I convert all my stored Outlook emails to the new program?

Thanks.

Answer:Office 2007 Home & Student - Adding Outlook or Another Program

Hello Hal06,If you are a student whose has a .edu e-mail address, you can purchase Office Ultimate 2007, which includes Outlook 2007, for less than the retail cost of Outlook 2007 alone. See:http://www.bleepingcomputer.com/forums/ind...st&p=921014

1 more replies
Relevance 61.09%

I am running Office Professional 2007 under W7 64 bit. I can open all programs from Explorer except Excel. This problem has surfaced recently but I don't know exactly the time and can't therefore go back to an earlier restore. I have looked on forums and see that one resolution is to untick 'Ignore other applications that use Dynamic Data Exchange (DDE) within Excel (Office Button/Excel Options/Advanced/General) but when I looked here it the box was already unchecked.

I have a 120GB SSD as C: with my data across an HDD configured as D: and E: (E: in this instance.)

Any help greatly appreciated.

Hallgente

Answer:Excel 2007 - There was a problem sending the command to the program

Hello Hallgente, welcome to Seven Forums.

This should hopefully solve your problem:
Excel Error: There was a problem sending the command to the program

7 more replies
Relevance 60.68%

Last night my daughter was doing homework on one of our computers working in Word 2007. She took a break for dinner and when she returned to the computer she was unable to open any office product. After looking further I determined that most of the .exe's in the Program Files(x86) were not working. I have tried several things with limited success. Norton 360 and Malwarebytes did not pick up anything. Since I am not sure what the cause of the problem is I started here.

Answer:Unable to run .exe from Program Files(x86) ie Office 2007 products, Adobe reader

Please download MiniToolBox  , save it to your desktop and run it.
 Checkmark the following checkboxes:  List last 10 Event Viewer log  List Installed Programs  List Users, Partitions and Memory size.
 Click Go and paste the content into your next post.
 Also...please Publish a Snapshot using Speccy - http://www.bleepingcomputer.com/forums/topic323892.html/page__p__1797792#entry1797792 , taking care to post the link of the snapshot in your next post. 
Louis

16 more replies
Relevance 60.27%

Office 2007 Configuration wizard runs every time I start any Application (word, excel, etc)
This takes about 4 to 5 minutes then the chosen program appears.

Can anybody help, I have tried all of the fixes I could find on the net to no avail.
Mike
 

Answer:Office 2007 Configuration wizard runs every time I start any Application (word, excel

Re: Office 2007 Configuration wizard runs every time I start any Application (word, e

Hi Mike


What Windows version (including 32/64bit) are you using and what version of Office 2007 as I had seen this with Enterprise version before but not the others?

Was this a new clean install of Office 2007 and its happening each time or just appeared?

Is this happening in the Admin or Limited accounts or both?


This could be a potential as did work on one PC I worked on, that said doesnt work for all http://support.microsoft.com/kb/911682

or if this is on Limited User accounts, temporarily change their account details to give them admin rights, then log in on that account, run one/all of the Office apps so that this installer runs, then reboot and log in again to check, if works ok then revert their account back to Limited User.
 

2 more replies
Relevance 60.27%

I have a spreadsheet that shows all of the upcoming events at my work (I've attached a very basic example of the way the spreadsheet is set out).

When an event passes, I'd like the spreadsheet to automatically change the formatting of the rows that contain events that have already passed.

For example, today being 14.12.09, an event for yesterday (13.12.09) would be highlighted in red to show that the day has passed.

If anyone can provide any detail on how to achieve this, I would greatly appreciate it.
 

Answer:Solved: Conditional Formatting Based On Date Range In Microsoft Office Excel 2007

Select your data, then Format > Conditional Formatting.

Condition 1; Formula is:

=$A5<$D$2

Click Format > Patterns > red colour > OK.

Click OK.
 

2 more replies
Relevance 59.86%

This is a D630 newly formatted Dell laptop and the user has had it about a month. Yesterday she noted that opening any Office 2007 program (but particularly Word) was very slow. I checked it out, and noted that in the bottom left of the Word document, when first opening Word it said " Contacting C:\Program Files\Microsoft Office..... for information

Outlook said the same thing.

Other users that started at the same time as she did and using the same model of laptop (and same image on the laptop) are fine and not experiencing this problem.

I disabled antivirus and all add ons, no change.
I ran diagnostics, which found one issue (that it did not name) that it said it fixed, but no change
I took out the printer drivers, no change
I repaired office, no change
I checked for any recent updates, nothing since June 19th. She has the latest Office updates (inc SP2)
I checked she didn't have something strange in the TCP/IP bindings.

Anybody have some idea?
 

Answer:Solved: Office 2007 slow to open--says Contacting C:\Program Files\... for informatio

The Fix:
Run Regedit and navigate to the Word Data Key: whilst DATA is selected press
Delete. Word will create a new key when it is restarted.

Word Data Key

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Data
 

1 more replies
Relevance 59.86%

Hello,

When I try to open a 2007 Word or Excel document I recieve as an attachment in Outlook 2003, I get the following message:
"This action is only valid for products that are currently installed". Office 2007 compatibility pack was installed and it still did not work.

I then uninstalled Office 2003, uninstalled the Office 2007 compatibility pack and then I ran CCleaner to clean up the registry. I updated my OS (currently has Windows XP SP3) with all updates, reinstalled Office 2003, installed Office 2003 SP 3 and then reinstalled the Office 2007 compatibility pack.

I still get the same message when I try to open an Office 2007 attachment in Outlook 2003.

OS is Windows XP SP3 fully updated
Office 2003 SP 3 fully updated

Any suggestions?

Thanks in advance for any hel on this issue.

Feral Geek
 

Answer:Solved: Cannot open Office 2007 documents even with Office 2007 compatibility pack in

6 more replies
Relevance 59.86%

hi all i have a genuine 07 office pro that i am trying to install, i have previously tried a beta version and have also had office pro 2003 version on my laptop

when i start the cd it starts to initialize then says office 07 cannot install as previous version of 07 have been found uninstall before continuing

i have gotten rid of all traces that i can find through the registry in safe mode with uninstaller pro but i still get the same error

i am running media center with an upgrade to vista premium
 

More replies
Relevance 59.45%

Microsoft Office (Word, Excel, Outlook)  and printer Slow When Connected To Network, But Fast When Not. with windwos vista , I have reintall the OS but still the same .
network environment  (Win server )

Answer:Microsoft Office 2007 (Word, Excel, Outlook) and printer Slow When Connected To Network, But Fast When Not.

Hi,
 
Please temporarily disable the third party security programs and boot in
Clean Boot
to test this issue.
 
Also, please
create a new user account
to test the issue.
 
Regards,
 
Sabrina
This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question.
This can be beneficial to other community members reading the thread.

2 more replies
Relevance 59.45%

good day all

curious as to how do i change ms office program icons ie excel, word i have office 2010

i can change other programs but not these ones.

Many Thanks in ADV

DME

Answer:how to change office 2010 program icon ie excel word

Originally Posted by dmesal


good day all

curious as to how do i change ms office program icons ie excel, word i have office 2010

i can change other programs but not these ones.

Many Thanks in ADV

DME



The possible Installer Created shortcuts may hold certain privileges,

create copies of the shortcuts and change the icons of those.

0 more replies
Relevance 59.04%

Hello, today the automatic update performed
Cumulative update 1703 and
MS Office 2007 update, the KB numbers follow
KB4038788
KB4038806
KB3213649
KB3213646
KB3114428
KB3213642
KB4011086
KB3213641
KB4011064
KB4011063
KB4011062

on a machine with CZECH Windows, Office 2007 installation was also Czech.

After the update, my Outlook 2007 started to speak half Czech and half Swedish or what
(see image). Can that be fixed?

More replies
Relevance 57.4%

Need Help !

I want to install Ms Office (reguler) 2007 or Ms Office Professional 2007,

but my setup is always go to Ms Office Enterprise 2007 Setup !

1. How can i fix that setup normally ?
---------------------------------------------------------------------------
2. My Problem number 2 :

>>>


(how can i fix this warning ?)


What should i do ?

Thx very very very much for help.

More replies
Relevance 56.99%

Hello. I have some .xls files on a cd which I could open fine until yesterday. The files were created on my Acer Aspire 5732Z (Microsoft Windows 7 Home Premium system x64 - based pc) using Microsoft Office Excel 97-2003.

Yesterday, I opened the cd on a different laptop (Acer Aspire 5733 64 bit operating system - windows 7 home premium, service pack 1). This laptop opened the files using Microsoft Excel starter 2010. I saved the files back to my cd when I'd finished, then safely ejected the CD using the correct method.

Now when I insert the CD into either pc, it show the CD drive but there are no visible files, so I can't open anything. I tried the error checking tool, but it can't check for errors as it says "windows cannot access the disk".

Can anyone help me open the files please? I have all the files backed up elsewhere, except for the two I worked on yesterday, but I really don't want to have to type them up again unless I absolutely have to as it will take me many hours. Any help would really be appreciated. Thanks in advance!
 

Answer:Solved: Cannot access Office excel 97-2003 .xls files after opening in Office Excel S

6 more replies
Relevance 56.58%

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.
 

Answer:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that

Pedro
 

3 more replies
Relevance 56.58%

I am desperately hoping that someone can help me with a problem I've got.

I have a range of values (daily financial figures) that are all made from formulas and external sources (other spreadsheets in the same document). None of these values have been directly entered, and the formulas behind them are quite complex. These values (one in each cell) are all read by a graph - however, for days in the future, the graph violently plummets as it's reading the cell values as "$0.00".

Can someone tell me how I can prevent the graph from showing the "$0.00" values? Is there a way to get it to ignore the cells with that value?
 

Answer:Getting A Graph In Microsoft Office Excel 2007 To Ignore "$0.00"

16 more replies
Relevance 56.17%

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

More replies
Relevance 54.94%

hello, i bought a new laptop a few months ago and rather than install my office xp pro, i chose to download the office 2007 small business trial and have been using this for 2 months including outlook for which i have many emails. my problem is i now want to use office 2007 pro and have bought an upgrade product, but to get this on my laptop i 1st need to install office xp pro then upgrade! if i bought office 2007 pro full product would this just install over trial or do i have to uninstall trial beforehand?what will happen to any files i have saved in office and also my emails? i cannot afford to lose any emails so how do i go about doing this? any help much appreciated.

More replies
Relevance 54.53%

My question is regarding MS Office, in particular, Excel 2010 and Excel 2013Our small business is currently using MS Office 2010.One of our guys who's job is to prepare data in Primavera wants to test Primavera in Excel 2013.My questions are: If I install Excel 2013 on his computer, will it show up as a separate entry in Programs and Features?If the testing with Primavera is completed and I want to remove Excel 2013 from the computer, will that affect the existing MS Office 2010 install on the computer?Will current MS Office data be affected by Excel 2013 being removed?Thanks

Answer:Excel / Office 2010 compatability to Excel / Office 2013

As these are two seperate applications, yes you can install office 2013 on the same machine as 2010 as a side by side installation, it will appear as a seperate entry within Programs and Features, so yes you can uninstall it at a later date.

8 more replies
Relevance 52.48%

http://www.ideawins.com/

Admit it.
You've got one.
We believe people everywhere have great ideas. But they do no good trapped in your head. We want to help you turn them into a flourishing business by taking the hassle out of accounting and business management. So we're offering Microsoft Office Accounting Express 2007 software absolutely free! No strings attached. Get your free download here.

More replies
Relevance 52.07%

Running Vista Ultimate (32 bit) on HP Media Center Desktop Unit (8100y). Each time system is booted up and Outlook 2007 is accessed for the first time, Microsoft Office 2007 begins to reconfigure itself. Neither canceling of the configuation process nor allowing the process to complete seems to have any apparent effect on subsequent operations.

Performed repair function on the Office application without any discernible effect. Any help in resolving this issue would be truly appreciated!
 

Answer:Starting Outlook 2007 causes Microsoft Office 2007 to reconfigure itself

8 more replies
Relevance 51.66%

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.
 

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

13 more replies
Relevance 51.66%

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
 

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

1 more replies
Relevance 51.66%

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.
 

More replies
Relevance 51.66%

I am running windows 7 on a new computer. Outlook 2007 is freezing many times after it is opened. I click on an e mail and it just freezes.
Word has done it also but not as bad.
 

More replies
Relevance 51.66%

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows 7 Ultimate , 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU T5750 @ 2.00GHz, x64 Family 6 Model 15 Stepping 13
Processor Count: 2
RAM: 3070 Mb
Graphics Card: ATI Mobility Radeon HD 3400 Series, 256 Mb
Hard Drives: C: Total - 113859 MB, Free - 60738 MB; D: Total - 110275 MB, Free - 61717 MB;
Motherboard: Acer, Inc., Chapala , Not Applicable, LXAQB0X612826017F32500
Antivirus: AVG Internet Security, Updated and Enabled

For no apparent reason my version of MS Outlook has suddenly gone belly-up. All other apps. in Office work fine.
When I now try to open Outlook I receive the following "Cannot open your default email folders. The file C:\User\Maurice\AppData\Local\Microsoft\Outlook\Outlook.pst is not a personal folders file"

I have tried uninstalling and re-installing Office from the original disks a number of times, I have successfully installed this on another Win7 desktop computer partition and it works fine. I have attempted to follow the MS repair online notification for .pst but it doesn't seem to work (or maybe it is me that isn't working). Most frustrating. Any word by word suggestions greatly appreciated.
 

More replies
Relevance 51.66%

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

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

7 more replies
Relevance 51.66%

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.
 

More replies
Relevance 51.66%

Many users who have upgraded from Microsoft Office 2003 to Office 2007 may find Office 2007 a bit difficult because of the new toolbar and arrangement of buttons. So, there is a free add-on for Office 2007 called UBitMenu which will add the menu bar and toolbar of Office 2003 in Office 2007 under a ribbon named as Menu. Download Link More Info Homepage

More replies
Relevance 51.66%

Just bought a new laptop with Windows7 64bit installed-my first exposure to Windows7. I had Office 2007 installed on my old Dell 32 bit machine. I had also recently pruchased Office 2010 and installed that on my new machine.

Now, when I try to open those 32bit 2007 files with 64bt 2011, Iget an error message that "no picture file is available", or words to that effect. When I try to "open with", the only option displayed is "Microsoft Office" with an icon that looks like a picture file. When I try to browse to the proper office program(Excel, for example), there are none of teh Office suite programs displayed, only "Microsoft Office".

I can navigate seperately to the proper progran, Excel, etc., and drag the file into the application, and it opens, and all seems to work OK. I "save as" the proper application file, but it still will not open with double-click on the file name.

I have not seen this particular item in the forums and would appreciate very much some help in fixing this issue.

Thanks,

Grubby

Answer:Office 2010(Win7, 64bit) won't open Office 2007(WinXPr3 32 bit) files

Hello Grubby76, welcome to the forum.

We have an excellent Window 7 File Association Tutorial here:
Open With - Change Default Program

2 more replies
Relevance 51.66%

Free Office 2007 To Office 2010 Upgrade Period Starts Today

Microsoft plans to release the final version of Microsoft Office 2010 on June 15 and is ? as always ? offering free upgrades for users who happen to purchase the previous version of the Office suite shortly before that release. In a blog post over at Technet Microsoft announced that the free upgrade period starts today which means that users who purchase Office 2007 from today on will be eligible for a free upgrade to Microsoft Office 2010 once it comes out.
The process works the following way:
Purchase Office 2007, or a new PC with Office 2007, and activate it between March 5, 2010 and September 30, 2010.
Have, or create a Windows Live ID.
Redeem your Tech Guarantee before October 31, 2010 by visiting www.office.com/techg.

More replies
Relevance 51.66%

Hello,

Reinstalled all Sony Pre-Loaded software,
which did NOT include any Prior version of MS Office. (Other than a Trial
Version of Office 2003 which I never used or installed. It's still in my
computer) Have no idea what version it is. Simply doesn't say because it's never been installed. It's sitting in the same start menu as all of the other MS Office 2007 Programs.
In another message forum I was told to delete it. However, Office 2007 Pro worked fine for 2 days with the Trial program still sitting in the Start folder.

I managed to install MS Office Professional 2007 and it's worked
for 2 days without a hitch. Today, I get the error message when I try to use
Outlook "Cannot start MS Office Outlook. Cannot initialize MS Office Shared
Utilities. Restart your computer Or reinstall MS Office Outlook." No Luck!!
Also, when I try to start up MS Word, the message says "Not enought memory
to load Word." (I have 2 Gig of Ram and a 320 Gig hard Drive???)

When I insert the Office Pro 2007 disk to Reinstall, the message is: "The
path you have chosen does not point at a qualifying upgradable product.
Click Try again or Cancel to quit setup."

I also don't have ANY previous versions of any Office Suite program to use.
I had Office 2003 Pro installed but that was deleted when I purchased Office 2007 Pro. I do have the disks for Office
2007 Pro.

For the record, I am an American living in Cali, Columbia. It... Read more

Answer:Reformatted My Hard Drive And Cannot Reinstall MS Office Pro 2007 in Office Setup

8 more replies
Relevance 51.66%

Hello,

A charity is considering upgrading its workstations to Office 2013 from Office 2007.
They have lots of files in the .docx, .xlsx, .xlsm, and .xltm formats that they would need to access on a daily basis.

- Would the upgrade cause compatability problems with working with files created under these above formats?

Answer:Considering upgrade to Office 2013 - potential problems with Office 2007 files?

To my knowledge, they should not have any issues.

4 more replies
Relevance 51.66%

MS Office 2007 - Microsoft Office Document Scanning is not able to recognize the scanner.
Every time when given scan its giving error message "Scanner not responding".
But scanner working fine when using MS Office 2003 - Microsoft Office Document Scanning. Also it works with software called Desktop Bind V2.

OS: Windows XP 32-bit
Scanner: RICOH IS200e Network Scanner.
 

Answer:Scanner not detected by MS Office 2007 - Microsoft Office Document Scanning

check if you have installed all the office updates.
check if there are any latest scanner drivers, update the drivers for your scanner.
run office diagnostic and check if there are any errors
 

1 more replies
Relevance 51.66%

Good Evening Everyone,

I have a few questions concerning the Installation of 2010 Office. I know that I have to uninstall Office 2007. I have no clue on how to save or where to save my documents from Office 2007. The documents consist of Word, Excel, Powerpoint and a few various folders. Should I from the Start Menue click on Documents select all and copy. Where should I place this copy? Can It be left on my hard drive? After I install Office 2010 can I then copy the "Document File" and place in Documents. Will all the files end up in the proper place for their programs, Word files go to Word, Excel goes to Excel so on and so forth. Thank you so much for all your help and cooperation. It is greatly appreciated. I hope I described my situation correctly. I look forward to hearing from you.

Answer:2010 Office Professional Plus to Replace 2007 Office Small Business

But you don't have to uninstall Office 2007 to upgrade to 2010. That's the general rule as you can generally upgrade from lower SKUs to higher SKUs (Small Business to Pro Plus). As far as saving your documents, you can really save them wherever you like on your hard drive or on any CD or flash drive if you wish to do so. As far as file types, after 2010 is installed, they should all register properly for their programs so that Word documents open in Word, Excel Documents in Excel, etc.

Though if you have all of you documents already saved within "Documents" or "My Documents" or some other folder you've set aside and you want to uninstall 2007 before upgrading to 2010, the documents themselves will be retained when you uninstall, you just won't be able to really do much with them until you install 2010.

2 more replies
Relevance 51.66%

Good Day,

I've often used the Files and Transfer Wizard to move files in the Windows XP environment, including those for people moving from Office 2003 to 2007, however, I've just been asked to move a person from a computer that would result in them moving backwards from Office 2007 to Office 2003; is this possible? What concerns should be considered? Obviously if they have a number of documents saved in the 2007 it could be problematic, though could the compatibility pack offered by Microsoft offset that concern? Thoughts? Thanks.

Regards,
Jeff
 

More replies
Relevance 51.66%

I recently purchased a HP 530 laptop for our soccer club that came pre installed with Vista. During use of outlook, Excel etc it came up with a message asking for activation key & that we had 20 uses left to enter it (I presumed this was a trial version & activation code to be purchased). After 5-10 uses I decided to install Office 97 which I still had lying around from an old PC. This installed OK but the message was still appearing.

I then uninstalled Office 97 via add/remove programs & then did likewise for anything that mentioned office 2007 (I didn't do the actual uninstalling but am advised there were 4-6 office 2007 variants uninstalled). I then went to load office 97 back in but no go. It goes through the usual install process, enter key, select location to load (prog files/microsoft office) & then select type of install required (typical) & then the features (have selected all & just the basic office install).

Then it goes to the actual install process but just sits there with the bluey/green coloured screen with Microsoft Office 97 written at the top but goes no further.

I have checked add remove programs again & no mentions of office are listed.

I have followed the following fix I was advised about -

**********************************************************************************
By default, Office is installed to C:\Program Files\Microsoft Office. Using My Computer or Windows Explorer, go to that folder. Delete the E... Read more

Answer:Hp Laptop, Vista, Unable To Load Office 97 After Removing Office 2007 Trial Version.

Microsoft doesn't certify Office 97 to work with Vista: http://support.microsoft.com/kb/933305That being said, lot's of people on the web have gotten it to work with varying degrees of success.Ensure that you install the application in compatibility mode - both as "Run as Windows 98" and "Run as Administrator"Don't install Service Pack 2 - it has problems. But, from what I've read, it'll let you gracefully exit the SP2 setup if you started it.

4 more replies
Relevance 51.25%

I have Office 2007 on Windows 7.

When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen).

If, I switch to another open sheet/doc and then switch back the ribbon is accessible again!

I have uninstalled/reinstalled Office plus SP's twice but the problem persists, and, as is usually the case, this does not happen all the time but enough times for it to be really annoying!

Any ideas?

Thanks for your time on this

Neil

Answer:Cannot access the Ribbon functions in Excel 2007 or Word 2007

Could you please post a screenshot or two?
And what are file sizes (MB)?

1 more replies
Relevance 51.25%

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!
 

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

2 more replies