Microsoft Excel 2010

Burning Excel Files to CD

I would like to burn my excel files to cd and want to know if there is anything special that I need to do. They are already on my HD as files and I have the cd burning program that came with my Dell pc.

linked MS Excel cells containing only short texts returning #N/A?

I have several linked cells in my report file that contains text. 80% of them work OK but few of these linked cells are returning #N/A? Some of them got just two words.

Excel XLL Add-in

Anyone know how to set the description of a function's category, which appears in the Excel window supplements ? The code below just enter the category name...

macros to repeat a cell

I am looking for a macros to repeat any word that is in column "c" from "D to AA" in every 3rd cell for that respective row.

Date Reading Wrong Order

Currently showing the date as, "09/10/13" and is apparently stored as yy/mm/dd. This should be read as mm/dd/yy. I have tried reorganizing, but there seems to be a numeric value assigned that will not allow conversion.

I cannot unhide rows

on the row column to the far left I highlight the row above and below the hidden rows, right click and select unhide. Nothing happens.

getting rid of negative numbers

How do I get rid of negative amounts when using the pmt formula?

Windows8 Require much memory.

How do I get an "IF" string to recognize a date in a general format "01/**/2013"?

The "Countifs" function recognizes "01/**/2013" and counts all of the January 2013 references.

if I download Converting MS Works .xlr file to Excel

if I download Converting MS Works .xlr file to Excel - Microsoft Works, will this mess up my MS excel 2010 program?

how to fix

excel: not enough system resources?

Currency and Text in Same Cell

I DON'T SEEM TO BE GETTING A RESPONSE FROM ANYONE FOR MY QUESTION, BY i SEE THAT OTHER QUESTIONS ARE BEING ANSWERED.

CAN SOMEONE PLEASE HELP ME WITH MY QUESTION!

Error Message from copying a worksheet from one workbook to another workbook

The error message:
A formula or sheet you want to move or copy contains the name 'Account,' which already exists on the destination worksheet. Do you want to use this version of the name?

Error Message "Run Time Error 1004"

We use an Excel spreadsheet to track sources and uses in funds for different project. Each draw, we record separately and then use a macro to keep track of each draw.

Multi part identifier could not be bound -error in VBA EXCEL but not in SQL

I am using a join query which runs perfectly in SQL . But when I try using it in VBA code in MS excel and then run the macros , I get the error - Multi part identifier "abc.xyz" could not be bound .

Excel not responding

I can go to my most used saved excel file, but can't open any others. Been occurring for about two weeks after running fine forever.

Need Help on clicking menu and submenu items.

Hi,
As per new org process, we need to automate the "Document Classification". The steps are
1. Open any existing docuement.
2. Click on "Classification" Menu.

Compare a column of substring with another column of strings and get count

Hi,

Below is the scenario. I have 2 columns. Column A has some article Ids (IS123, IS1234, etc.). Column X has Solutions provided to customer, where this article Id would be a reference (substring.)

How do I remove a password from a protected workbook?

When I developed this workbook, I protected it with a password.
I want to remove the password now and cannot find how to remove the protection.

Generate random number w/ in a specific range

I would like to generate a list of random number w/ in a specific range.

Example numbers and format:
00
10
20
30
40
50

Pages

Subscribe to RSS - Microsoft Excel 2010