2
votes
1answer
631 views

How to copy the network path of the open workbook in Excel 2007 to the clipboard?

I want to write a VBA function for Excel 2007 (as well as Word 2007 and powerpoint 2007) which: copies the complete network path of the open workbook or file to the clipboard. I'm working a lot ...
2
votes
3answers
2k views

How to store VBA Macros for Office 2007 to have them always available and share them with others?

I have created some useful VBA macros for Word, Excel Outlook and PowerPoint 2007. Now I want to have them always available in the corresponding application via keyboard shortcut or icon to click ...
3
votes
1answer
2k views

How to create a new group of radio button in Excel without interference?

Status: I have a form with sections on the same page, in each section the user can only chose one solution. I'm using group of radio buttons on Excel 2007. Problem: When I ad a new group, the buttons ...
0
votes
1answer
343 views

Can I update multiple Excel 2007 Pivot Tables data drop down one time?

I have about 50 Pivot Tables in Excel 2007 that need a drop down updated on a daily basis several times to reflect multiple pieces of data from the page I have of data. It is very time consuming to ...
0
votes
1answer
329 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
3answers
17k views

Search text in multiple Excel files

I'm using Microsoft Office 2007. How can I search inside multiple Excel files?
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 ...
3
votes
1answer
429 views

How can I disable the 'your formula has an error' pop-up in Excel 2007?

This is driving me absolutely crazy, while I'm in the middle of typing my equations into a cell I like to pre-create the parenthesis sometimes when order of operations is being explicitly set, however ...
-1
votes
3answers
294 views

Macros Excel 2007 - extracting data

Im trying to extract certain data from a cell and trying to put it somewhere else within the same cell. Any suggestions? EDIT I have several text strings in ONE cell (a date, a part number and a ...
2
votes
3answers
1k views

When I click on an Microsoft Excel .xls file, it says “There was a problem sending the command to the program”

Odd error: if I click on an Excel 2007 file to open it from within explorer, it says "There was a problem sending a command to the program". Excel opens - but it doesn't open the file. I have to then ...
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 ...
0
votes
1answer
100 views

Route MS 2007 excel file in

Can the MS excel 2007 file also be routed in outlook just like the way it used to be in 203 link text I was not able to find the option in fil>send
3
votes
3answers
8k views

How to disable moving down on Enter key in Excel 2007?

There used to be a check-box in preferences in Excel 2003 to disable moving down on Enter key after you edited a cell. Where could I find that setting in Excel 2007? <whining on>It drives me ...
0
votes
1answer
2k views

Un-table a cell range in Excel 2007

In Excel 2007, if you highlight a block of cells and then "Format as Table", it doesn't just apply colors and formatting, it somehow marks those cells as being a table. Now I want to get rid of the ...
0
votes
2answers
3k views

Copying and rotating large table from Excel to Word without turning it into picture/wmf/

What would be the easiest way of copying and rotating a table made in Excel, to Word without turning it into a picture/enhanced metafile/or something alike. I know I can use the Section Break ...
1
vote
3answers
8k views

Excel 2007 does not close properly

I've noticed some odd behavior with Excel 2007 and I'm curious if others have seen this. When clicking the application close (big red X), Excel actually closed down the open workbook, yet leaves the ...
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 ...
3
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 ...
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 ...