Hello to all readers,

I have a problem exporting the reports generated by SAP to Microsoft Excel. Whenever I import my report, Microsoft Excel XL reporter rejects my report.

XL Report

Security setting in Microsoft Excel prohibits XL Reporter from running

For more information, click Help.

I've been doing this task for many times already and this is just the first time I encountered this error message. I've been reading some articles in the internet, but none fit with the scenario I have. This problem gives a lot of head ache to me since I will be delayed on all my works in solving this issue.

Hi buddies, I am posting here an issue I encountered while opening an Excel file. I pasted below the error message for reference.

Microsoft Office Excel

A  DDE error has occurred and a description of the error cannot be displayed because it is too long.

If the filename or path is long, try renaming the file or coping it to a different folder

Good morning guys,

I am opening an Excel file I saved last time but when I opened it now I got an error. (See the image below for the error).

I don't know why I am getting this error since the last time I used the same Excel file, it worked.

Thanks.

Error:

C:UsersABRACOSADocumentstechyv.xlsx

There was a problem sending the command to the program.

I have a database of contacts in Excel sheet. Much duplication of numbers exists in the list. I want to remove the duplicate of any number from the list. Guide me how I remove duplicate numbers from the list of database?

I'm not so into MS Excel, a newbie friend in MS Excel show me some works and ask about it, shown below.

He wants to work it like this, as shown below.

How will he work so that the paragraph will be arranged in just one cell as shown above?

How to show different currency in Excel Currency Format.

I am working in a small company which deals with Money Exchange. We buy money from different denominations. I want each columns of my report show the actual currency symbol of the money using the currency format.

My primary currency is “US$” and on the next column is “PHP”, next is “HK$” and so on. Figures should be shown as it is required above.

Thanks for the help.

Column number conversion to Excel Alphabet Columns

I want to fill with data each cells horizontally through VBA. The data is consisting of multiple rows and columns and its columns are ranging from 50 to 500 columns.

The range object uses the array of Cell Address which is in this format [column (alphabet)] [rows (numeric)]. To define this in my program I need to convert the numeric column, like for instance 27 which is AA on the Excel Column. It should be increasing like how the Excel column was arranged. A VBA functions is what I need. 

Thanks for the help.

Good day!

While it is true that we can use the Fraction format in the Number group (Home) to enter fractions as fractions and not date

(such as 1/5 and not 5-Jan, etc.).

How can we prevent Excel from automatically rounding off to 1/2 for fractions that are actually equal to 1/2 but we want it displayed the way we key-in the fraction (e.g. 3/6, 4/8, 5/10, etc).

Thanks a lot

JOMAR

When I am working in MS- Excel, I tried to copy row to row. But it became like below:

Flowing in another row. I can't change the settings. There is an auto save mode in my Excel. I tried to change it but failed. What can I do now? I'm using MS Office 2007 in Windows 7.

In Microsoft Excel I type SL No. in one column.

There I use 1,2,3. After type 1,2,3, drag and drop and full fill some rows.

It’s very easy for me. Saturday, Sunday, Monday; January, February is also easy.

But now I need to type a, b, c, d, e in one column with the help of drag and drop column.

How can I complete the task?