3
votes
2answers
107 views

Setting default editor language in word 2007

I want to change my default editing language in word as English (India). It is not so possible to change the language setting in all users and all PCs manually. Manually we can change the default ...
0
votes
2answers
852 views

Dragging Excel formula involving INDIRECT

=INDIRECT("'"&$A4&"'!E4") This is supped to use the value from cell E4 of the sheet with name found in A4. In fact it works. But when I drag this formula across multiple columns/rows, the A4 ...
0
votes
1answer
1k views

Excel sheet column names had changed from A, B, C to 1, 2, 3

Somehow column names in my Excel sheet got changed from A, B, C, ... to 1, 2, 3, .... Could anyone please tell me how to change the column labels back to A, B, C?
0
votes
1answer
602 views

How to bypass latest MS Excel security annoyance?

Right off the bat let me say that I open this Excel file only on my home desktop computer. The file has some script that populates the table with the stock prices off the Internet. So every time I ...
0
votes
1answer
104 views

How to tabulate data of street house price history for graphing in Excel?

I have data for all the historical sale prices of all houses on my street... so for each house I have a list of at least one date/£price point. I want to enter this into an Excel spreadsheet so that ...
11
votes
5answers
26k views

How do I force excel (and other office products) to stop opening files in the same application?

Whenever I "double click" on an Excel file and another Excel file is open, the newly opened file automatically opens in the same application window as the previously opened Excel file. This isn't ...
0
votes
1answer
335 views

Using Excel 2007 Pivot Tables/Graphs linked to WORD questions

I am using Excel 2007 and using several pivot charts which reference the same table of data. I change the data daily, copy and pasting the data from another source. I have several questions: Is it ...
1
vote
2answers
1k views

Excel doesn't automatically update ranges in SUMIF expression — why?

In Excel 2007, I have a worksheet arranged like this: A B C 1 x 2 15 2 x 3 45 3 x 4 ...
1
vote
3answers
17k views

Search text in multiple Excel files

I'm using Microsoft Office 2007. How can I search inside multiple Excel files?
0
votes
0answers
2k views

Stretch an Excel table in PowerPoint over multiple slides?

I work in a business where most people run on PowerPoint and wouldn't know what to do with an Excel sheet if it bit them. I need to regularly update a spreadsheet and put it into PowerPoint, but it ...
0
votes
2answers
335 views

Connecting Adobe Reader with Microsoft Excel

I am making an Excel sheet to help me to be able to easily track my ebooks and ebooks being read. so my Excel sheet contain the name of the book and the total number of pages, the current page I've ...
5
votes
2answers
305 views

Can I use lookup with multiple lookup values?

I am working on a project that utilizes client and vendor data. Basically, once a client's contract is awarded to the vendor, I can enter a key (a 3 letter acronym of the vendor name) on the client ...
1
vote
1answer
204 views

Office custom toolbar location

I have created a custom toolbar in my Office package (e.g. Word, Excel, Outlook). My profile got corrupted so I have to create a new profile. Does anyone know where the location of these toolbars is ...
1
vote
2answers
515 views

Excel: How do I convert multiple row entries in a column as a percentage of the total entries in another cell?

Example: Under column B row 10: mop row 11: top row 12: cop row 13: mop In another cell in another column, I'd like to know the percentage of the word "mop" (50%) and another cell would be the ...
1
vote
1answer
2k views

Getting VBA error when opening Excel 2007 on new computer

I have a user with a new computer that whenever Excel is opened gives the error message Opening the VBA project in this file requires a component that is not currently installed The message is ...
1
vote
2answers
44 views

MS Excel 2007 ref

How to transfer data Row to Columns?
3
votes
4answers
18k views

Quick way to convert Excel sheet to XML

How do you easily convert an excel file into a XML file? When trying to save as an XML File, it complains that the file does not have an XML mapping. Clicking help brings up pretty complicated stuff ...
2
votes
5answers
6k views

Very slow copy-paste in Excel and word 2007 on Vista

I'm using Office 2007 on Windows Vista and occasionally, when copying from Word to Excel, or text from a website to Word, I will get the hour glass for 10 + seconds and sometimes for about a minute. ...
2
votes
2answers
2k views

Open blank Excel spreadsheet with all cells in text format by default

When I paste data with leading zeroes to a newly-opened blank Excel document, it strips out all leading zeroes. Is there a way for me to open up a new instance of Excel (not from a template, I ...
4
votes
5answers
11k views

How can I make Excel documents open in different windows?

Office 2007, Windows Server 2008 x64. How can I make Excel so that when I double-click a document, it opens in a new Excel instance, so that I can easily view them side-by-side as separate windows ...
0
votes
1answer
1k views

Office 2007 Compatibility Pack and .XLSX Issues

I've installed the Microsoft Office 2007 Compatibility Pack and Service Pack 2 on client machines. In one case the user reports he can open .docx files successfully but is unable to open .xlsx files. ...
3
votes
2answers
9k views

Split Excel table over multiple PowerPoint slides

I have a table in Excel which is too long for one PowerPoint slide. So I would like to split it over 2 or 3 slides, but have the header on each of the slides. What is the easiest way to accomplish ...
5
votes
2answers
14k views

Setting up a column of “enum”-fields in Excel

I'd like to setup a column in excel with several fixed possible values (like 'in-progress', 'done', 'canceled'). I'd like to set it up so the only possible values in these column are from the fixed ...
2
votes
7answers
4k views

How do you put data from a web table into Excel?

I'm trying to build a spreadsheet from a few different webpages that have data in a table format. How do you put data from a web table into Excel?
1
vote
4answers
13k views

Excel 2007 | Remove blank fields from pivot tables

Every time I create a pivot table (available for all Excel versions) I get one or several blank fields. How can I get rid of them? One workaround I used was to select the blank field, right click | ...
76
votes
12answers
247k views

How do I compare two Excel documents? [closed]

The compare function in Word 2007 is very handy -- is there a similar capability in Excel 2007? I can't seem to find it... The documents I'm trying to compare are essentially two versions of the same ...