I am working on a schematic of an engineering drawing and I would like to be
able to have a picture of the piece of machinery pop up when I click a cell
that referrences it on the schematic from a picture library on the Excel book
I am in.

I have a strange problem when I do a sort on data which has other sheets
linked to it.  When I sort the data, the other sheets seemed locked to the
cell rather than the data.  
For example, if sheet1 contains cell A1 with the formula ='sheet2'!B2 and I

I hope I can explain myself clearly enough to explain what I want to
accomplish.  I'm using columns B through G and sometimes H.  What I'd like to
have happen is if I hit enter after typing something in column H then the
cursor will go to the cell in column C of the same row ...

I have written the following PrintFiles() procedure to print 3 worksheets
from an external workbook.  The code will look in column A for a list of
workbook files.  There will be many workbook files (50+) with the same
worksheets to print.  If it finds the file, then it opens the ...

Is there any way to visually see which cells are locked and/or which cells
are unlocked?
TIA,
Sammy

If you have more than one item in the "Row" section of a pivot table the
display only shows the label in the first column once if there is more than
one value in the second item.  Is there a way to get the pivot table to
display the value in the first item and not leave blanks?  ...

When I open Excel 2007, the ribbon and rows open with very 'wide' or 'tall'
heights.  I checked the row height and it opens, by default I guess, at 87.75
and the Formula Bar seems even larger.  I do not have this issue in my other
Office apps (Word, PowerPoint, etc.).  Thoughts?

I have a worksheet that I perform a subtotal on using the subtotal wizard in
the Data toolset.  The wizard inserts a row and the subtotal formula based on
the criteria entered.  Therefore, the preceding cells (non-uniform range) are
values and the inserted row is a formula.  I ...

Hello there...
I have two spreadsheets (in two separate workbooks) that are linked and my
question is "is there a way to have Excel automatically open the second
(dependent) workbook when I manually open the first...so, I'm actually

We've tried this on multiple computers and this problem only occurs on
one of them. When we add any control from the control toolbox to the
sheet it displays with a 'X' in the upper left corner of the control
and nothing else appears or works with that control. I can view

how do i add records to the end of an already created excel spreadsheet?

When I am using Excel and want to select a single cell with my mouse, I click
on the cell but I get multiple cells instead. Of course I can still use the
keyboard to change its size, but that takes too long.

We have database which start with name as clientTrans and suffixed with years
..  e.g. 2000,2001,2002,2003....and for the yer it only clientTrans (without
suffixing year).  So year is passed through a variable, surprissingly, the
following codes runs properly (when year is "" ...

I have a "Master Workbook" that (with VBA) moves worksheets out to other
workbooks located in subfolders in the same shared drive.  My problem is that
I can't move a worksheet if another network user has that particular workbook
in the subfolder open (and nothing tells me that it ...

I can't minimize any worksheets, and I can't select New Window under Window
(grayed out). How can I minimize and then view multiple worksheets in Excel
(XP)?