Guest guest Posted May 5, 2002 Report Share Posted May 5, 2002 Dear Krushna, Sanjay and others members of the list, If you don't mind could you send to the list the basic + sarva & summary= 2 sheets, it will help us. Thank you very much . Thank you to Krusna, Sanjay, Dona ..... for the good job. liliane - S J Monday, April 22, 2002 8:35 AM Re: samdharmi Dear Margarita,Just a non-astrological suggestion. Instead of attaching the wholeworksheet, you could just attach the summary page. Just follow the followingsteps to create a new file for the summary worksheet.1. Press control A to select the whole sheet.2. Click on new workbook.3. Once you have the bland workbook on the screen, right mouse click on thefirst cell and select paste special on the context menu.4. From the options that you get, select formats. The format will now appearon the blank sheet.5. Then choose paste special again and select values. You will have thevalues and the summary sheet complete in the new workbook.6. Save this in the directory convenient to you.This way, you would have most of the relevant information in an under 50kemail instead of an 850k email. It is fine for me but some people withslower connections might have some trouble with that.RegardsSanjay Quote Link to comment Share on other sites More sharing options...
Guest guest Posted May 10, 2002 Report Share Posted May 10, 2002 Dear Liliane, I am sorry for the delay in reply but I am very busy with some other things these days and will be for some more days. I think there might be some confusion. To calculate the summary sheet, you need the whole worksheet. The summary just picks up some parts from the detailed worksheet. It is not a substitute for the main worksheet. The idea of sending an extract of the summary sheet is just to reduce the size of the email in case someone wants to discuss a worksheet without having to enclose the whole lot of about 800k. Or maybe I have not understood what is it that you want and some other member can help you out. Regards Sanjay - " Liliane " <lilihir Sunday, May 05, 2002 7:37 PM Re: to send the worksheet Dear Krushna, Sanjay and others members of the list, If you don't mind could you send to the list the basic + sarva & summary= 2 sheets, it will help us. Thank you very much . Thank you to Krusna, Sanjay, Dona ..... for the good job. liliane - S J Monday, April 22, 2002 8:35 AM Re: samdharmi Dear Margarita, Just a non-astrological suggestion. Instead of attaching the whole worksheet, you could just attach the summary page. Just follow the following steps to create a new file for the summary worksheet. 1. Press control A to select the whole sheet. 2. Click on new workbook. 3. Once you have the bland workbook on the screen, right mouse click on the first cell and select paste special on the context menu. 4. From the options that you get, select formats. The format will now appear on the blank sheet. 5. Then choose paste special again and select values. You will have the values and the summary sheet complete in the new workbook. 6. Save this in the directory convenient to you. This way, you would have most of the relevant information in an under 50k email instead of an 850k email. It is fine for me but some people with slower connections might have some trouble with that. Regards Sanjay Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.