Hi all, I would like to open another program, (MYOB), by clicking its picture that I've pasted to a worksheet. I know how to assign a macro to the picture...

An excel file suddenly grew from 5M to 16M when I pasted a link to a pivottable. Is there any way to reduce this filesize? Thanks, caroline

I don't want to use Merge Cells because I'll be inserting horizontal rows. Any ideas?

Convert existing Excel into Data source document to link to existing Mail Merge document to create multiple letters for mass mailings?

When I opene an excel file is opening a blank book1 spreadsheet, ...

Sudenly when I try to open Excel 2003, instead of opening with a new blank worksheet, I get a folder named Analysis and it has 4 files, or...

Hi guys, Firstly my thanks go out to those who sort out the problems of us minions. I've learnt so much from these posts that I never thought possible - keep...

I have a weight spreadsheet which has been running for the past 3 years and have just now set up a dynamic weight chart covering the last 100 days based...

How do I search for duplicate entries in an excel list?

I have a program created in 2003 that has a TOC page with links to about 46 sheets. The sheets have the code Private Sub...

Jim, I appreciate your reply, however the clipboard is not being clearerd. When I switch to the destination workbook I can paste from the clipboard but...

I have applied filters to an excel spreadsheet. When I select a value from the filter drop down it used to display the count or total number of records inthe...

The new explorer bar in windows XP explorer window is a good idea. it allows a list of commonly used functions grouped by type, and hidable under it's group...

Is there a way to set up a column of numbers so that it automatically updates the numbers every time a line is added or deleted?

Let's say I have a workbook containing multiple worksheets, each a separate materials requisition. I want to find out when (and details) I last ordered a...

How would I make a Fx. that would add $500 + 4% interest each mouth? A1 B1 C1 ie 500 +4% = =+500 +4% = =+500 +4% =

Try this: =A1&TEXT(A2,"000000") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may...

Hi all, Given time in mm:ss and distance in general decimal form (eg 5.5 miles) is there an effective way to write a formula to express the distance per...

Hi, we have a timesheet with comboboxes, we generally create copies of the master sheet within the same workbook. Having comboboxes on the master sheet and...

I keep loosing my settings in Excel. Periodically, my toolbars reset back to defaults and my custom toolbars are gone. Also, my custom colors I set...