Search:

This is great - is it possible to display images that are separate .jpg files? I want to create a file with photos of students interviewing with different companies. There are several hundred...

Do the built-in Excel web queries which retreive live stock prices from MSN Money work with international stocks?

Thanks!

Larry

When using the “paste link” feature to place an Excel chart in a Word document, we are receiving the message along the lines of “Do you want to re-open cases – these are already open” in some cases...

Is there a way to add items to the pop-up menu that appears when you right-click in a cell in Excel 2007?

Thanks.

Larry

Thanks Rory - I was afraid of that!

Larry

Rory,

That's what I was afraid of - thanks!

Larry

I teach an Excel class and several students have Macs. They need to use the Histogram and Regression tools, but can't find/turn on the Data Analysis tools - where are they/ They are using the 2003...

We download a report with hospital patient information every morning in .CSV format - see attached file (I had to change the file type to .txt to upload - original file extension is .csv) - and need...

Does Access have an Excel-like "Clean" function? Is there an easy way to remove carriage return, line feeds and other nonprintable characters from strings or memo fields in Access?

Thanks!

Larry

thanks Hans - sorry - could find this when searching. I'll try to do better next time.

Larry

I am creating a database which creates brochures. Each brochure will contain eight .jpg files - each based on user entry in combo boxes. Instead of storing the .jpg files as attachments in tables,...

In Access 2003, there was a easy method to create a new query from an open table or query (this was a drop-down item on the toolbar which allowed easy creation of new forms, queries, etc). This was...

Thanks Hans (Duh!! I must have created the database in 2003 before the upgrade). Anyway, the attachement type works perfectly. Thank you - thank you - thank you - thank you - thank you - thank you -...

How do you create an attachment field - it's not one of the standard data types (text, memo, number, date/time, currency, autonumber, yes/no, OLE object, hyperlink) - or is it the hyperlink field...

I have create a OLE field in a table to store images and then use a bound object frame to display the picture in a report. Bitmap files (.bmp) work fine, but images in .jpg or .gif format display the...

Thanks - Outlook 2007 was loaded onto the same PC that ran Outlook 2003 - I'll check to see if the file is there. Will copying this file allow modifying the macros on the "Add-ins" ribbon?

Larry
...

I created a custom toolbar in Outlook 2003 with buttons calling macros which auto load email addresses into the "to" line for the folks I always send email to. When my software was updated to Outlook...

What would you want the QAT button to do? A worksheet function is not something you can "run" or "execute" like a macro.

I'd like to fill a cell with a function that I use all the time instead of...

Is it possible to add a specific function, like NPV to the Quick Access Toolbar or do you need to write a macro/VBA?

Thanks!

Larry

Is there a way to have Excel default to display two decimal places each time a percentage is entered? For example, entering 5.1% and 5.102% would both automatically display at 5.10%. I know that we...

I will work on the PC - here is another questinon -

What keys should be used to select non-contiguous cells on a Mac?

Thanks.

When I try to select the second set of cells, the first set of cells is no longer selected - is there a configuration problem?

How do you change the default so that a pivot table will allows default to calculating average? (or count? or max?)

Thanks!

Larry

Older versions of the Excel were limited to 1000 items in the filter - has this been increased in 2007?

Larry

I want to graph two blocks on non-contiguous data in Excel (example A1:14 and D1:D14). In earlier versions of the program, you just selected A1:A14, held down the control key and used the mouse to...