problem in retrieving data from excel report

i have reports in excel 11.0 ver on one of my friend computer.when he sent 
those files as attachments ,i could not see the data but some code was 
there.the version that i have is excel 9.0.

could you please tell me where the problem is .


Kanth (2)
12/5/2004 6:57:03 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 27


Could you open the files, but looks like gibberish?

Have your friend send the email with attachments as "Plain Text" not RTF

Gord Dibben Excel MVP

On Sun, 5 Dec 2004 10:57:03 -0800, "kanth" <>

>i have reports in excel 11.0 ver on one of my friend computer.when he sent 
>those files as attachments ,i could not see the data but some code was 
>there.the version that i have is excel 9.0.
>could you please tell me where the problem is .

12/5/2004 7:28:10 PM

Similar Artilces:

encoding problem in Outlook 2007 importing Outlook 2000 personal folders
I use Outlook 2007 to import the pst file of Outlook 2000. The Chinese characters in the subject became unreadable but it's ok to display in message body. In Outlook 2000, there's no problem to display the Chinese characters in the subject. What's wrong with Outlook 2007? What setttings should I change to fix the problem? Thanks. cyl <> wrote: > I use Outlook 2007 to import the pst file of Outlook 2000. The Chinese > characters in the subject became unreadable but it's ok to display in > message body. In Outlook 2000, there's no problem t...

List of DDE commands for Excel
Hi, I wont to send some commands from my application to Excel via DDE. Fo example : to select specific sheet in the excel workbook I use nex command - [WORKBOOK.SELECT("sheet-name")]. But I can't find the list of all these commands. Please help me -- Message posted from If you have a look in the object browser in the excel visual basi editor it will have a list of the VB commands excel will accept and i you hit F1 on them it will tell you what they do and usually giv syntax. Dunca -- Message posted from 2 DNF Karran Th...

Problem shortcuts in Word
Hello, I work with Word 2008. In the beginning there is no problem, but suddenly i have problem with shortcuts. When i want to do "cmd c" it make an other shortcuts same thing for "cmd s", "cmd v" and surly some other. But when i write there is no problem "c" is "c"... If somebody have an idea please help me. Thank you. Unless you indicate your specific update level of Office as well as OS X & describe what the keystrokes *are* doing contrary to what you expect there isn't much we can offer. -- Regards |:>)...

Outlook 2003 PST problems
I just installed Office 2003 professional on a new computer & am having problems with outlook. I copied my Outlook.pst file into the appropriate directory & although it is recognized the calendar is not working properly. I cannot attach any of the colored labels to my appointments - so everything is pretty much in black & white. I totally uninstalled & reinstalled office... first removing my pst file... but there appears to be an ini file... or something that is retaining some information... does anyone know of a fix for the labels... or how to TOTALLY uninstall office (so I...

Item History Report
I have modified the item movement history report to get an essential output for my client, who's main concern when purchasing is on the history of the item (needs to know when, who, quantitiy, and multi currency + exchange rate at time). The reason i modded the Item movement history report is because it is easy accessible from the purchase order (although he has to double click on the item to bring up the item form and then click on the report button, which brings up the default filer for the itemlookup code in question). The only issue with this report is that it brings up a filte...

How do I link data workbooks to a create a graph?
I am attempting to take workbooks from the last 4 months, each with a daily data sheet, and link Mondays, Tuesdays, Wednesdays, etc. to time of day and staffing levels. I want the final result to be charts that show the relationship between staffing levels, incoming call volume, and time of day. hi Andrea, Many things are possible in Excel & I'd say that you could probably find a way of linking all the workbooks. However, I think any "easier" approach would involve opening each file & copying the data from each sheet in each file to a single sheet in one file (with...

pop3 connector mail retrieval schedule
Greetings I have enabled the pop3 connector for Exchange on a Small Business Server 2003 installation. Everything works beautifully on the Outlook 2003 (client) side with pop mail sending and receiving except for one unexpected glitch. I can only set the connector to retrieve mail from the pop server at a minimum of every 15 minutes. Why was this done and is there any way to overcome this serious inconvenience. Thanks in advance to anyone who might answer. There's no way to change the SBS pop connector polling interval. Is there some reason you really need to keep the POP conn...

Excel copy and paste #2
Excel 2000 1) there are times when I can only paste values and not formulas from one workbook to another even though I am using Edit/Copy and Edit/Paste process. 2) there are times when I cannot copy and paste between workbooks launched from Edit/Copy, Edit/paste, or CTRL C, CTRL V or from shortcut menu. The only way is to use the clipboard which does not copy formulas. we have referred to 209338 and 209284 but the stated solution doesn't always work. ...

Problem with Authentication
The CRM application was running smooth. But now I can't logging. It ask my credentials and than return a 401.1 error. I had already reinstalled the CRM server but it won't work. I'm accessing it in the same local network. I'm running CRM 3.0 in SBS. Best regards, Erico Hi When you open a Internet explorer and type the name of the CRM server, it prompts for user and password ? Are you logged in with domain credentials ( AD user ) ? If you are, so add url of the crm server in Local intranet. Enable "Automatic logon only in intranet", this is under security,c...

Vista blue screen problem...please help!
I've seen some other threads, here are the dump files: 'RapidShare: 1-CLICK Web hosting - Easy Filehosting' ( Please, help me out here. -- ceVil It might be better to know at what point the bsod occurs and what the actual err.msg given is "ceVil" <> wrote in message > > I've seen some other threads, here are the dump files: > 'RapidShare: 1-CLICK Web hosting - Easy Filehosting' > (...

How do I assign X = the value of 1 in a cell in Excell 2003?
How do I assign X = the value of 1 in a cell in Excell 2003? That need some explaining. Excel genially goes use variables but rather uses cell references. Cells can be given names (such as x) but it is not required. Tell use more about what you wish to accomplish best wishes -- Bernard Liengme remove CAPS in e-mail address "Givens" <> wrote in message > How do I assign X = the value of 1 in a cell in Excell 2003? Put a 1 into any cell - let'...

calendar problem
Dear all, I am using both mail and calendar function in outlook 2002. Everything is ok until recently, when I try to make a new appointment or checking any old appointments, an error message "out of memory or resource, try to close some windows..." pop up. The mail function is still ok. Can anyone tell me how can I solve this? I have already installed sp2. The version of office is the professional one with frontpage. Thanks. tp ...

format of emailed excel file
In excel 2003 when I email a a particulat worksheet in a workbook I lose all the formating when it is recieved in Outlook 2003. Is there anyway to preserve the excel "look"? Thnaks, Craig S ...

Report Writer Logo Printing
I remember a software being recommended that was a pass-through printer software that would allow printing of higher-quality logos. It is a workaround for people that did not find the logo printing of RW suitable. I cannot think of the name or find the software. A nudge in the right direction would be appreciated. Thanks, Mike Found it! Software is called fineprint. It was mentioned on Musgraves blog. "Mike" wrote: > I remember a software being recommended that was a pass-thr...

Copy Filtered Data
I am filtering my data that is in the range A:AJ starting on row 13 with headers and having a variable ending row. My filter criteria is Column 1 not blank and Column 11 ="s". I would like to copy the filtered date (No headers) to another work book beginning in BE3. Thanks! Hi, Once the data is filtered, highlight it, press CTRL + G, special, visible cells only, press CTRL + C, go to the sheet where you want the information and press CTRL + V "" wrote: > I am filtering my data that is in the range A:AJ starting on row 13 > wi...

problem #4
Hi, I am facing this new problem... i.e a user has installed Office 2003 on win2k prof platform.. whenever she is working on a outlook.. she gets a Microsoft error message... saying to send the report or don't send the report... Usually I have seen this problem in IE... But for outlook it is new to me... after clicking on send or don't send report.. the outlook closes. And there are no IE open..... and if atall it is open.. the IE does not close... Need your help regards, KAH What is logged to the Event Viewer regarding this? Try one of the following already; http://www.howt...

95 and 97 problem
For some unknown reason there is Excel 95 and 97 on this pc.When i double click on an Excel file, the pc defaults to the 95 program (Which incidently doesn't work properly). So my question is how do i get the pc to default to 97. Cheers Craig Craig, Have a look at Windows Help. From Windows 2000 Help (Index under Programs Associating with File Types) To change which program starts when you open a file In My Computer or Windows Explorer, on the View menu, click Folder Options. Click the File Types tab. In the list of file types, click the one you want to change. Click Edit. In Act...

Need to change Autofilters behaviour in Excel 2003
Hello, Does anybody knows how to change the color of the triangle arrow on the column titles of autofilter ranges? Presently, when a filter is put on one column, the arrow for this column is changed from black to very dark blue. I need to change this color, so that this becomes more visible. At our office, my boss cannot make any difference between these two colors. This is a problem for daily work. Thanks in advance for any help. Bertrand from Tokyo, Japan see response to your earlier posting -- Regards Roger Govier Bertrand wrote: > Hello, > > Does any...

sync problems
I have all of my info on an HP Ipac. I had to reformat the hard drive and I did not make a back-up file. I am trying to move everything back to the computer but it says there is an error with syncing it. How can I move everything from the PDA back to Outlook again? Please help- thanks ...

AS400 transfer into Excel 07
When I run the "transfer from AS400" I get to the final process where its pulling the data into excel, excel crashes with a fatal error. Any help.... This is the same issue I am having. see KB933666. I installed Office 2003 service Pack 3 on all my office machines and the new service pack features security fixes that block all *.wk4 files. This is the same patch that has been applied to Office 2007. This is the format, I think your are exporting out of the AS400. If it is, I would uninstall office 2007, make sure the folder is deleted then reinstall Office 2007 after a reb...

how to skip a column when entering data?
On one worksheet, for the sake of appearance Column B contains a calculated amount, which is the product of Column A and Column C. Is there a way to skip to column C when entering the data in Column A without doing it manually? Thanks, Godzilla This will give you the idea. right click on sheet tab>view code>insert this>SAVE Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Row > 2 And Target.Column = 1 Then ActiveCell.Offset(, 2).Select End Sub "Godzilla" <> wrote in message news:MPG.19e3d6a7ae92e03398971a@news....

Date problem
I can't believe there's no post on this, but I can't find it. I've tried the solutions I could find (see below) and still get the error: "The expression is typed incorrectly or it is too complex to be evaluated. For example....Try simplifying...." I have a date field, formatted as Date/Time, General Date, default Value = Now(). I like having the date and the time - in case we need it. I want to run a report on calls taken just for one day. I have CallDate: CallDateAndTime in my query, with "criteria" as Between ([Forms]![frmReports]![txtStartDate]) A...

data return based on two criteria
Hello, I have the following data in excel A2:A5 - cells are merged and contains partnumber (alpha numeric & numeric) C1:AF1 - DATE C2 - initial stock (number) C3 - receipts data (number) C4 - production (number) C5 = available stock (C2+C3)-C4 Similar data is maintained for 25 partnumbers I would like to have a sheet where the users can input date & partnumber and get available stock data. Your help will be highly appreciated. Regards, Jimmy Joseph Hello, Help please! Jimmy Joseph <> wrote in news:Xns97DB7A8693AB8jimmyjosephinboschco@clien...

Data Ribbon disabled
I'm trying to do a "what-if analysis" for my beginning Excel class and when I click on the appropriate cell and then the Data ribbon, all of the options are greyed out. While struggling with this, I noticed the options on the Insert ribbon are also greyed out but the other tabs are fine. I appreciate any insight. Hi, Check the Review tab, the worksheet may be protected. Check you do not have multiple sheets selected, [Group] will be displayed in the title bar is you have. Cheers Andy Akcath wrote: > I'm trying to do a "what-if analysis"...

Installation Problem!!
I am having a problem installing MSCRM 1.2. My configuration consists of a Domain Controller running Win 2000 Server SP4 . I am trying to install MSCRM on a member of the domain running Windows 2000 Server SP4. There is a DNS Server on the DC which is integrated with AD, and a SQL Server 2000 running on the Win 2K machine. The install errors out when CRM creates the root business with the message: Setup was unable to install Microsoft CRM Server. Setup was unable to provision your organization. Setup was unable to create the root business. The configuration of ASP.NET seems to be ok, the pr...