100% CPU usage for 1+ minutes during save and print preview

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - MORE HELP WITH TIME FUNCTION I have a cell (E11) that has calculated the hours worked 'D11-C11(D11>C11)'. If that amount is greater than 5.5 hours (which it usually is), I need to subtract a one half hour meal period from the total. I have tried '=IF(D11-C11>="5:30",D11-C11-"0:30",D11-C11)' but it does not work. What am I not doing or doing wrong? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108048
  - 2
    - Possible to do a calc on certain rows? Hi all, In 23 days time I am off around the world for 10 years. I have a pal TX and have found that I can use excel spread sheets. I already have budget set in MS ACCESS that is accessable online, but I would like budget in Excel so I can keep up to date as we travel around. In my budget I have the following columns (A1) Type (food, accommodation) (B1)Price (c1)Days (d1)Place then the following rows have the main information (A2)accommodation (B2)100.00 (c2)2 (d2)Auckland (A3) food (B3)60 (c3)2 (d3)Auckland (A4)Sightseeing (B4)40 (c4)1 (d4)North Shore Now is it possible to do something like select all days (column c) where type = food (column b) and then sum the total? The way that the budget (in access) works is that the days under th food type is used to work out the cost per day, which is why I need t be able to call the sum of the days for food only! Advise on how to do it and how to enter it would be most appreciated! thank you for your time : -- kotitiaher ----------------------------------------------------------------------- kotitiahere's Profile: http://www.officehelp.in/member.php?userid=504 View this thread: http://www.officehelp.in/showthread.php?t=125710 Posted from - http://www.officehelp.i Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108046
  - 3
    - Find and Replace problem hello all... first... thanks to all who offer their expertise..... this group has been a wonderful asset. My problem.... a few weeks ago I built a spreadsheet whereby I could enter time quickly by simply typing, say, 12.45 and the spreadsheet would automatically replace the . with a : on the fly. I set that find/replace routine up so that I could use the number pad to enter the times on the fly. Now, no matter what spreadsheet I open it will replace the period with a colon. And for the life of me I can't figure out/remember how I set it up or how to make it stop..... aaarrrggghh! Help.. thanks to all glen Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108042
  - 4
    - How to make an image into a command button? Does any one know how to turn an image into a command button? or a toggle button? The standard command button is retangular, and i want to make it into a different shape, i tried editing its properties and inserted an image , but the image is contain inside the rectanglar shape.. not in its orginal shape, which is an arrow shape Jay Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108041
  - 5
    - Word table of Contents automatically linked to Excel? Hi I am wondering if this is possible: I have a word document that contains a TOC (table of contents). Is it possible to automatically import the TOC into excel? I have tried embeding the document but it imports the entire document, i only need the TOC. Any help would be appreciated. Thanks :) Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108040
  - 6
    - "Executive Summary" report I'm trying to set up an executive summary worksheet or report that would be automatically (or semi-automatically) updated as the underlying data changes. A simple example to illustrate my scenario: Assume an "Employees" worksheet: [Last Name][First Name]....[Status] Where "Status" could be something like [Probation | Part Time | Full Time | Contractor | Departed] (ensured using a validation list). Users would adjust the status of the employees frequently, so the number of users in each category changes. Certain managers want a view of the relevant data, and they'd like a worksheet that only shows Probation, Part, and Full Time employees formatted underneath large headers, so from "Employees" [Last Name][First Name]....[Status] Smith | Carol | ... | Part time Jenkins | Leroy | ... | Contractor Doe | John | ... | Full time Public | John | ... | Probation The "Executive Summary" sheet would display ***********FULL TIME************ John Doe ***********PART TIME************ Carol Smith ***********PROBATION************ John Public And nothing more. I cannot for the life of me figure out how to do this. Does anyone have any pointers? (I'm using Excel 2004 from the Mac version, but PC or Mac doesn't matter excessively). Pointers, hints, or suggestions would be great, as none of the reporting tools I can find seem to provide this sort of functionality. -- "Live with cause and leave results to the great law of the universe. Pass each day in peaceful contemplation." -Zengetsu Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108034
  - 7
    - CSV incorrect worksheet name when downloaded from web MSIE6 Hello, When I use the follwing aspx code to get a csv file via Internet Explorer in MS Excel, after comfirm dialog box as "Open content immediately" Excel displays a corrupt worksheet name as given in: Response.Buffer = True Response.ClearContent() Response.ClearHeaders() Response.Charset = "" ... Response.AppendHeader("content-length", reportOutput.Length.ToString()) Dim type As String = Request.QueryString("Type") Dim strFileName As String = Request.Params("FileName") ... Response.ContentType = "application/csv" Response.AddHeader("Content-Disposition", String.Format("attachment;filename={0}.CSV ", strFileName)) ... Response.AddHeader("Content-Transfer-Encoding", "binary") Response.BinaryWrite(reportOutput) Response.Flush() Response.End() then the CSV file opens as: '.CSV]fille_name[1]' This worksheet name cannot even be edited to eg. 'table_1'. Excel does not accept any typing, complaining "wrong characters". If I write the file to disk instead of opening it in Excel, everything works fine when I try to open the saved file afterwards. I don't have a clue on this... however the HTTP headed looks to come back correctly from the server: HTTP/1.1 200 OK Date: Thu, 09 Nov 2006 17:01:31 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET MicrosoftOfficeWebServer: 5.0_Pub X-AspNet-Version: 2.0.50727 Content-Length: 7092 Content-Disposition: attachment;filename=Data_Export3732.CSV Content-Transfer-Encoding: binary Cache-Control: private Content-Type: application/vnd.ms-excel Following the example from this header... the worksheet name will open as follows in Excel: .CSV]Data_Export3732(1) Thanks for any guide... Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108031
  - 8
    - How do I save to csv and get text delimeters? I'm using Excel 2003 and when I save a file as a CSV it does not ad the text delimeter. I get Smith,John A Instead of "Smith","John A" How do I get the text delimeters? I've tried setting the format to text instead of general Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108030
  - 9
    - Summing Times in hh:mm:ss in text I'm stumped. I have a column that I'm trying to sum up. The column looks like this A 1 11:59:37 2 18:13:29 3 12:48:39 Its in hh:mm:ss format and its pasted here in text, so its not an actual value. Now when I do something like: =A1+A2 I get the correct answer in the Excel decimal date format (1.259097222) But if i do this: =Sum(A1:A2) I get a ZERO. I can add as many as I want in this format: =A1+A2+A3 and so on and it will continue to work. But the sum NEVER works. Why, and more importantly, how do I fix it? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108022
  - 10
    - Worksheet protection I have a work book with over 120 worksheets. Is there any way to set the worksheet protection on all worksheets so that a user can only select unlocked cells. I know I can do this by selecting each worksheet, one at a time, and deselecting all options but "select unlocked cells", but that will be very time consuming. Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108020
  - 11
    - Please help! Move and size with cell is not avaliable We're trying to get the option, but no matter what we do when we make new checkbox, the option is never avaliable. Is there any possibly wa that we can get that? I really don't know what to do, please, someone help me out! Heathe -- FloridaHeathe ----------------------------------------------------------------------- FloridaHeather's Profile: http://www.officehelp.in/member.php?userid=502 View this thread: http://www.officehelp.in/showthread.php?t=125638 Posted from - http://www.officehelp.i Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108009
  - 12
    - Problem Extracting Data From A Generated List Having a problem trying to use MATCH, INDEX and SUMPRODUCT to produce a list from some data. In row 1, I have Business Process Numbers (BP's) in this format: 1.01 44.01 46.02 46.03 46.06 which start at 1.01 and at the moment go up to 60.27. There are currently 146 BP's. The column under each BP has a list of Attribute numbers from the range of 1 to 1300 and this may very well expand in the near future. Due to the amount of Attributes, these obviously have to be placed Vertically. The attributes are arranged in numerical order in each column but there may be duplicates and the length of each column is not fixed. BP 44.01 has 0 attributes, BP 46.03 has 29 attributes. I need to produce a list that will give me the BP's associated to an Attribute Number so i can automate a copy process. For instance, Attribute 14 is associated with BP's 46.21 and 46.22. I would need to be able to see the following: Attribute BP1 BP2 BP3 BP4 16 11.10 46.02 46.03 46.30 17 46.21 46.22 I would be eternally grateful if someone could assist please. Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108002
  - 13
    - How do I get this option avaliable? I'm trying to insert check boxes on the excel spreadsheet. We have th entire page laid out, and now we're trying to insert the check boxes but there is one option unavaliable. When I click format and go t properties, Move and size with cells is not avaliable, is there anywa to make it avaliable? I'm unsure if its possible. Please, if someone can reply asap it'd be big help! Heathe -- FloridaHeathe ----------------------------------------------------------------------- FloridaHeather's Profile: http://www.officehelp.in/member.php?userid=502 View this thread: http://www.officehelp.in/showthread.php?t=125632 Posted from - http://www.officehelp.i Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 108001
  - 14
    - Move forumlas to another sheet but keep references to first sheet I need to copy a section of one sheet to another. The section contains formulas referring to the same sheet. When pasted into the second, the formulas should refer to the same cells on the first sheet. If I copy a formula with relative references e.g. =sum(A1:A5), it is pasted as =sum(#ref!). If I paste a formula with an absolute reference, e.g. it is pasted as the same absolute reference e.g. =sum($A$1:$A$5) which refers to the current sheet, not the originating sheet. What I need it to be is =SUM(Sheet1!A1:A5) How do I do this? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107994
  - 15
    - Further Show Hide Problem with VBA Hi again! Bob kindly gave me a suggestion for using VBA to show /hide using a single button. This worked fine until I decided I wanted to have another custom area off to the side. The problem being that when I try to return from this third view not all rows columns are showing. I thought I might get round this by including an unhide for all rows and columns to create a normal view to go from but then the toggle views don't seem to do anything. Any help greatly appreciated DonH Call Unl Application.ScreenUpdating = False Rows("25:75").EntireRow.Hidden = Not Rows("25:75").EntireRow.Hidden Rows("98:148").EntireRow.Hidden = Not Rows("98:148").EntireRow.Hidden Rows("244:294").EntireRow.Hidden = Not Rows("244:294").EntireRow.Hidden Rows("317:367").EntireRow.Hidden = Not Rows("317:367").EntireRow.Hidden Range("K4").Select Calculate Call Pro -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "DonH" <d.hart440@ntlworld.com> wrote in message news:WIB4h.25197$Ib.15825@newsfe1-gui.ntli.net... > Hi hope you can help. > > I know next to nothing about VBA and have adapted code below from stuff I > had. > > I simply want to show hide portions of my page to cut down on screen > clutter/information overload. > > I have assigned my macro to a screen image but was wondering if I could have > a hide and unhide under the same button. > > Any help would be much appreciated > > > > Call Unl > Application.ScreenUpdating = False > Rows("25:75").EntireRow.Hidden = True > Rows("98:148").EntireRow.Hidden = True > Rows("171:221").EntireRow.Hidden = True > Rows("244:294").EntireRow.Hidden = True > Rows("317:367").EntireRow.Hidden = True > Range("K4").Select > Calculate > Call Pro > > > DonH > > Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107993
  - 16
    - display data form chosen record of a list Hello there! I'm a little newbie to excel and i want to do something with some records. I have some lists of records in a sheet for example cities Athens Kavala Thessaloniki ---------- ---------------- ---------------- ---------------------- Athens 15 35 89 Kavala 26 85 90 Thessaloniki 89 23 34 I want a list in a new sheet that will contain all the records form cities and when i chose a record for example Athens, to display on the cell below all the records that "Athens" contains : 15,26,89. I have made the lists but i dont know how to display the data from every list when i make the selection. Does anyone know how to do this and is this possible???? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107991
  - 17
    - Charttitle.Text crashes (Excel 2000) Hi, when I try to run the following code (on an existing diagram): With ActiveChart Dim globalLstFile as String globalLstFile =3D "02 KOBA_XYZ_C3-06214 02- 20.7-20.8=B0C Touchprobe Mittelpunkte.lst" =2EHasTitle =3D True =2EChartTitle.Text =3D "KOBA Sphere Gauge S/N 38 538 (" + globalLstFile + ")" & Chr(10) & _ "color coding: red =3D Zone 1, green =3D Zone 2, blue =3D Zone 3"= & Chr(10) & _ "light color: measurements that contain spheres that are within 20 cm of the edge of the measurement volume" .=2E. Excel returns with the error 1004. However, if I set globalLstFile to "test", then the code runs just fine. I did not find any limitation on .ChartTitle.Text, but I am suspecting that it is limitied to a certain number of characters or does not allow special characters. Any enlightment would be greatly appreciated (sorry for the horrible formatting of this text). Blackno666. Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107988
  - 18
    - Hyperlink from Different File to Specified Worksheet I have 2 Files (File1.xls and File2.xls). Both files have 3 worksheets. How do I create hyperlink from File1 to File2's Sheet2 worksheet? Hope you might help. Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107984
  - 19
    - VBA using an image as a toggle switch Hi hope you can help. I know next to nothing about VBA and have adapted code below from stuff I had. I simply want to show hide portions of my page to cut down on screen clutter/information overload. I have assigned my macro to a screen image but was wondering if I could have a hide and unhide under the same button. Any help would be much appreciated Call Unl Application.ScreenUpdating = False Rows("25:75").EntireRow.Hidden = True Rows("98:148").EntireRow.Hidden = True Rows("171:221").EntireRow.Hidden = True Rows("244:294").EntireRow.Hidden = True Rows("317:367").EntireRow.Hidden = True Range("K4").Select Calculate Call Pro DonH Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107983
  - 20
    - How to create "frames" in Excel 2003? Hi all, Is there a way to create frames in Excel like one can do for webpages? For example if I split my sheet vertically, I want a frame on the left side which has "links" that if I click them change the sheet I'm viewing on the right side. Thank you! Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107978
  - 21
    - Generating XML from Excel2002 using XSD Hi I understand that XL2003 offers nice XML features that could do what I want easily. But I am not sure about what XL2002 Pro can let me do. I need to generate pretty basic XML in Excel 2002 VBA. I have an idea of my XSD schema - say Author --> [Name -once ]/[Email- unbounded]l/[Book -unbounded --> Title/Publisher/ISBN] Data comes from Excel Can you give a basic code of how I should use VBA in conjunction of the XSD file I have access to msxml and msxml4 DLLs Thanks a lot Ben Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107977
  - 22
    - Filtering Hi to all, I have worksheet nammed HCP2006. colomn EK has numbers in some of it's cells. The code below is to select only the rows that has numbers (not blank) in colomn EK starting from row 6. These filtered rows has to be copied to another worksheet in the same folder that has the name WV_KP_06 which containes 12 sheets for 12 months and according to the month (here it is June). When cells in colomn EK is empty (all blank) an error occures the code does not continue. I want to add a Message box telling that there is nothing to be filtered and to return every thing as it was before starting the code. Note: this code is run when pressing a button on the HCP_2006 worksheet. Thanks in advance, Khalil Handal Here is the code: Sub KP6() ' Month of June06 KP Dim RngToFilter66 As Range Dim RngToCopy66 As Range Dim Destwks66 As Worksheet Dim DestCell66 As Range Dim LastRow66 As Long With ActiveSheet .Unprotect Password:="1230" 'turn off any existing filter .AutoFilterMode = False Set RngToFilter66 = .Range("EK6", .Cells(.Rows.Count, "EK").End(xlUp)) RngToFilter66.AutoFilter Field:=1, Criteria1:="<>" If RngToFilter66.Cells.SpecialCells(xlCellTypeVisible).Count = 1 Then 'no visible rows in filter. Set RngToCopy66 = Nothing Else With RngToFilter66 Set RngToCopy66 = .Resize(.Rows.Count - 1, 1).Offset(1, 0) _ .Cells.SpecialCells(xlCellTypeVisible) End With End If .AutoFilterMode = False .Protect Password:="1230" End With Set Destwks66 = Nothing On Error Resume Next Set Destwks66 = Workbooks("wv_KP_06.xls").Worksheets("Jun") On Error GoTo 0 If Destwks66 Is Nothing Then Set Destwks66 = Workbooks.Open(ThisWorkbook.Path & "\WV_KP_06.xls").Worksheets("Jun") End If With Destwks66 ' delete any previous lines after row 7 Worksheets("Jun").Select Rows("7:50").Select Selection.ClearContents Range("A7").Select ' previous line added by me LastRow66 = .Cells(.Rows.Count, "B").End(xlUp).Row + 1 Set DestCell66 = .Cells(LastRow66, "A") End With RngToCopy66.EntireRow.Copy _ Destination:=DestCell66 Application.CutCopyMode = False End Sub Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107976
  - 23
    - Counting cells Hi, I had this before, but it didn't work weel! I may have not made it clear. Range C5:C29 containes either letter C or letter M. Range D5:D29 containes either letter M or letter F line 5 C F line 6 C M line 7 M M .......... In cell D34 I want to count the number of occurance of the combination of C and M. The array formula =COUNTIF(C5:C29,"C") counts the value of colomn C. What adjustment do I need to do to include the values in colomn D? I tried this: =COUNTIF(C5:C29,"C"), (D5:D29,"M") but had an error Khalil Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107972
  - 24
    - Counting cells Hi, I had this before, but it didn't work weel! I may have not made it clear. Range C5:C29 containes either letter C or letter M. Range D5:D29 containes either letter M or letter F line 5 C F line 6 C M line 7 M M .......... In cell D34 I want to count the number of occurance of the combination of C and M. The array formula =COUNTIF(C5:C29,"C") counts the value of colomn C. What adjustment do I need to do to include the values in colomn D? I tried this: =COUNTIF(C5:C29,"C"), (D5:D29,"M") but had an error Khalil Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107971
  - 25
    - Reference Grouped Objects Using VBA Hello I have grouped four charts, three text boxes (from the control toolbox) and a rectangle. Prior to grouping, the code I had to update the axes on both charts and text for the text boxes worked fine. After grouping the objects the code fails. How do you reference a specific object contained in a group? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107960
- Next
  - 1
    - excel time calculation I have a cell (E9) that has calculated the hours worked 'D9-C9(D9>C9)' and an adjacent cell (F9) to convert this to decimal ('E9*24'). If there is no entry in C9 and D9, F9 reads '-24'. How do I correct this to show 0.00? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107958
  - 2
    - Formula for 3 columns Example as to a formula I need Add Subtract Balance Column C Column I Column J $1000 -$500 =$500 All columns are set up to start with row C14 and finish with C100 I column starts with row I14 and finish with I 100 J column starts with row J14 and finish with J100 Columns C & I presently have amounts in each cell. Where there are no actual amounts, I have $0.00 to fill cell Column J has no figures at all except all cells have $0.00 Could someone please create a formula for me that would give me a continous running balance in Column J based on the above information -- Thank you in advance for your assistance HankL Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107956
  - 3
    - I"M STUCK! help please! here is what i want to do: 2 columns: A & B col A: list of months (12): cell A1:jan/06, A2: feb/06, A3: mar/06, A4: apr/06, A5:...... A12: dec/06 col B: list of sales that correspond to the month (only 4): B1:100, B2:112, B3:105, B4:112 I want a formula that will tell me the latest month that the sales is inputed (in this case B4) = apr/06 i've gotten the formula to find the last number of the set: which give me the number of "112" (i put this formula in D1) =INDEX(A1:A12,MATCH(9.99999999999999E+307,B1:B12)) or =LOOKUP(9.99999999999999E+307,B1:B12) but where i'm stuck at is using index/match, (i put this formula in E1) =INDEX($A$1:$A$12,MATCH(D1,$B$1:$B$12,0)) and in the example above, it would always return to me (feb/06) as it is the same sales figure as apr/06, but I want the formula to to tell me apr/06! i've also tried changing the match type to '1' and it did do anything. i feel i'm so close but cn't figure it out! Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107948
  - 4
    - I"M STUCK! help please! here is what i want to do: 2 columns: A & B col A: list of months (12): cell A1:jan/06, A2: feb/06, A3: mar/06, A4: apr/06, A5:...... A12: dec/06 col B: list of sales that correspond to the month (only 4): B1:100, B2:112, B3:105, B4:112 I want a formula that will tell me the latest month that the sales is inputed (in this case B4) = apr/06 i've gotten the formula to find the last number of the set: which give me the number of "112" (i put this formula in D1) =INDEX(E17:E28,MATCH(9.99999999999999E+307,B1:B12)) or =LOOKUP(9.99999999999999E+307,B1:B12) but where i'm stuck at is using index/match, (i put this formula in E1) =INDEX($A$1:$A$12,MATCH(D1,$B$1:$B$12,0)) and in the example above, it would always return to me (feb/06) as it is the same sales figure as apr/06, but I want the formula to to tell me apr/06! i've also tried changing the match type to '1' and it did do anything. i feel i'm so close but cn't figure it out! Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107947
  - 5
    - vlookup problem Excel 2002 SP3 Win XP HE SP1 *Follow-up group is: microsoft.public.excel* *only reply to: microsoft.public.excel* hi, i am having a problem with vlookup wherein if i use formula A: =VLOOKUP(A2,NJ!$C$2:$C$48,1, FALSE) it works but formula B doesn't: =VLOOKUP(A2,NJ!$A$2:$E$48,5,FALSE) the only difference is the table array range which in the formula B looks into the same sheet etc., but at more columns. i can't understand what is causing the problem. i believe that the columns do not need to be sorted (help file); the sheets are formatted properly, etc. i've done LOTS of vlookups in really complex spreadsheets in the past but am rusty right now and can't put my finger on what i am doing wrong. anyone can help? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107943
  - 6
    - Finding missing numbers in a list I have a series of client account numbers that range from 001-999. I first imported the client information from Timeslips which where we keep client information into an Excel spreadsheet. What I need to now do is create a macro or a query that will tell me what numbers are not being utilized from the spreadsheet that I created but I don't know how to do this. I have only created one macro before and that was with help from an instructor so I don't know where to begin can someone please help me with this. Lynne Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107933
  - 7
    - checkbox linked to a cell Hello, I am programatically trying to add a checkbox. but it looks like you have to give pixal locations ActiveSheet.OLEObjects.Add(ClassType:="Forms.CheckBox.1", Link:=False, _ DisplayAsIcon:=False, Left:=111.75, Top:=197.25, Width:=85.5, Height _ :=21.75).Select is there a way to add a checkbox and give the cell row / column? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107932
  - 8
    - Newbie Question open a web service in excel Ok here is where I am at.... I have created a web service in vs 2005. I have tested it and have been able to bind the content to a gridview....... below is my code: using System.Data.SqlClient; /// <summary> /// Summary description for dbconn /// </summary> [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class dbconn : System.Web.Services.WebService { [WebMethod] public DataSet GetTitleAuthors() { SqlConnection myConnection = new SqlConnection("Data Source=JEREMY1;Initial Catalog=pubs;User ID=sa;Password=beth123"); SqlDataAdapter myCommand1 = new SqlDataAdapter("select * from Authors", myConnection); // SqlDataAdapter myCommand2 = new SqlDataAdapter("select * from Titles", myConnection); DataSet ds = new DataSet(); myCommand1.Fill(ds, "Authors"); // myCommand2.Fill(ds, "Titles"); return (ds); } I have downloaded the "Microsoft Offiec 2003 Web Service" a have installed it..... I am able to add the web service and it creates the necesary file In excel I create a button and add the following code Dim wsAuthors As New clsws_dbconn Dim value As String value = wsAuthors.wsm_GetTitleAuthors() To be honest I am not sure how to return the 23 records that are in the ds to the excel grid... any help or bump in the right direction would be helpful Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107931
  - 9
    - graphiques comment eviter sur un graphique mensuel que la courbe ne retombe a zero les jours ou la plage de données n'est pas renseigne et que le dernier point a valeur rejoigne le suivant ? merci d'avance Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107930
  - 10
    - HELP WITH FORMULA I have 3 columns. C -I=J These columns are continuous and I keep adding amounts to cells in column C and deducting amounts from I column and need to end up with a total in column J. Could someone please help me with a formula that will continually give me a total to column J as I enter information into column C and deducting from column I. -- Thank you in advance for your assistance HankL Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107926
  - 11
    - IF Statement, Group Adding, Please help me I have a problem in using an If Statement and adding statement together. A B C D Carl 1 2 3 1 2 Luis 1 1 11 Jim 1 1 1 I am trying to make an if statement where if there is anything as in letters or words in column A, it will add whatever is in cell B and C. So the 2nd row plus the 3rd row plus the last row will equal to 7. Since the 3rd row has nothing in column A, it will not add C's value. I would need the answer in one cell that adds up the whole result to 7. Thanks for the help. Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107917
  - 12
    - Generating an EXCEL dataset with formating I have the need to generate an EXCEL dataset, not macro driven, which has formatting that just can?t be done in the CSV type of file format. Generally my requirements are for a 6 column table with bold column headings and a title line above the column heading that is also bold and in a merged cell of the 6 columns. Currently I am generating a .XML formatted document, but you have to remember to say Open with EXCEL or it opens in the browser and you see the code to generate the table not the table. The beginning of the code is below. Is there a better format that can be used, so EXCEL is the default format? Also where is the ?description of the format at? The dataset is being sent as an attachment to people, so I can?t control their machines and change the file associations. <?xml version="1.0"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Author>Kenneth Leidner</Author> <LastAuthor>Me</LastAuthor> <Created>2006-11-02T10:03:38Z</Created> <LastSaved>2006-11-02T10:03:38Z</LastSaved> <Company>XYZ</Company> <Version>10.6735</Version> </DocumentProperties> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> <DownloadComponents/> <LocationOfComponents HRef="file:///\\"/> </OfficeDocumentSettings> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>7935</WindowHeight> <WindowWidth>15195</WindowWidth> <WindowTopX>0</WindowTopX> <WindowTopY>45</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="s21"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <NumberFormat ss:Format="0000"/> </Style> <Style ss:ID="s22"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> </Style> <Style ss:ID="s23"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s24"> <Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/> <Font x:Family="Swiss" ss:Bold="1"/> </Style> <Style ss:ID="s25"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Font x:Family="Swiss" ss:Bold="1"/> <NumberFormat ss:Format="0000"/> </Style> </Styles> <Worksheet ss:Name="Book1"> <Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="265" x:FullColumns="1" x:FullRows="1"> <Column ss:Index="2" ss:StyleID="s21"/> <Column ss:StyleID="s22" ss:Span="3"/> <Row> <Cell ss:MergeAcross="5" ss:StyleID="s23"><Data ss:Type="String">The title line for the month of Oct</Data></Cell> </Row> <Row> <Cell ss:StyleID="s24"><Data ss:Type="String">C1</Data></Cell> <Cell ss:StyleID="s25"><Data ss:Type="String">C2</Data></Cell> <Cell ss:StyleID="s23"><Data ss:Type="String">C3</Data></Cell> <Cell ss:StyleID="s23"><Data ss:Type="String">C4 #</Data></Cell> <Cell ss:StyleID="s23"><Data ss:Type="String">C5</Data></Cell> <Cell ss:StyleID="s23"><Data ss:Type="String">C6</Data></Cell> </Row> <Row> <Cell><Data ss:Type="Number">1</Data></Cell> <Cell><Data ss:Type="Number">0597</Data></Cell> <Cell><Data ss:Type="Number">06283</Data></Cell> <Cell><Data ss:Type="Number">02510</Data></Cell> <Cell><Data ss:Type="String">CAY448</Data></Cell> <Cell><Data ss:Type="String">T0971A</Data></Cell> </Row> And repeat for each row. Then there is some closeing commands for the table and all at the end. ? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107913
  - 13
    - Output to excel Using standard DoCmd.OutputTo syntax to export a simple dataset to an Excel worksheet. Works well, but...... we have a list of text codes (YD, 2M, 7G, etc) which come across into the cells ok, all except codes like '11A', '10A' and the come into Excel as eg '0.458333333', '0.416666666666667' Reformatting as text/general has no effect at all Is there something I'm missing about the output process which would cure this quirk? Any ideas gratefully received TIA Steve Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107912
  - 14
    - Inconsistent formula evaluation in excel I have come across a somewhat frustrating problem in Excel 2002 when using if statements and then an evaluation which uses indirect addressing and match statements to perform an evaluation (subject to some preconditions in the if statement). My evaluation statement [MAX(E6:INDIRECT(ADDRESS(ROW(B6)-1+MATCH(B6+L$4/24-($B$7-Starttime),(B6:indirect(ADDRESS(ROW(B6)+L$4/(($B$7-Starttime)*24),COLUMN(B6)))),0),COLUMN(E6))))] works fine on its own, and works equally well inside a single if but, as soon as I put two or more nested if statements before the evaluation, Excel sates that there is an error in the formula and will only accept the formula once I have replaced the indirect(address()) statements in the match statement with fixed addresses (which sort of defeats the whole point). I am using this rather convoluted formula as I have a real world data set where occasionally data is completely missing and sometimes individual data points are blank but I need to perform an evaluation over a fixed time span - the indirect addressing therefore defines the range I need to act upon, which varies, as I say, over a large data set (perhaps 34000 rows). What I really cannot understand is why, when my evaluation statement works fine, and when it works fine as the final part of a simple if, what Excel might be objecting to when I put it as the final part of a 3 level deep nested if... I have checked and quadruple checked that the syntax is correct and that all brackets are matched and correct, etc, but cannot find any error in the formula and cannot find a way of getting Excel to accept my formula entry. For info, her is a simple version that works followed by a simple version that does not - although they nominally do exactly the same thing! 1 works [=IF(OR(E6="",E101=""),"",(MAX(E6:INDIRECT(ADDRESS(ROW(B6)-1+MATCH(B6+L$4/24-($B$7-Starttime),B6:INDIRECT(ADDRESS(ROW(B6)+L$4/(($B$7-Starttime)*24),COLUMN(B6))),0),COLUMN(E6))))))] 2 doesn't work [=IF(E6="","",if(E101="","",MAX(E6:INDIRECT(ADDRESS(ROW(B6)-1+MATCH(B6+L$4/24-($B$7-Starttime),B6:INDIRECT(ADDRESS(ROW(B6)+L$4/(($B$7-Starttime)*24),COLUMN(B6))),0),COLUMN(E6))))))] Any help or advice would be greatly appreciated. Many thanks and best wishes Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107911
  - 15
    - Looking for pattern or formula I have a set of data that is ranked. Based on the current rank and the desired rank, I would like to call upon a formula that will project changes to the input factors to obtain the desired rank. Anyone know what that formula or pattern is? Thanks A bit more explanation I would like to compute changes to base rate, factor1, factor2 to get company A to rank 2 desired rank for company A= 2 Company B-D are fixed and their result will not change. Factor 1 is the representation of territory and Factor 2 is the representation of class Table Layout Base Rate Factor 1 Factor 2 Result Rank Company Territory Class 100 0.5 0.78 39 1 A 1 1 41 3 B 42 4 C 40 2 D 100 0.5 0.76 38 1 A 1 2 60 4 B 38 2 C 56 3 D 100 0.5 0.65 33 1 A 1 3 38 3 B 39 4 C 36 2 D 100 0.5 0.32 16 1 A 1 4 25 4 B 17 2 C 18 3 D 100 0.5 0.5 25 1 A 1 5 31 4 B 29 3 C 26 2 D 100 0.65 0.78 51 1 A 2 1 59 4 B 52 2 C 58 3 D 100 0.65 0.76 49 1 A 2 2 56 4 B 52 2 C 53 3 D 100 0.65 0.65 42 1 A 2 3 53 3 B 44 2 C 53 4 D 100 0.65 0.32 21 1 A 2 4 36 4 B 26 3 C 23 2 D 100 0.65 0.5 33 1 A 2 5 37 4 B 36 2 C 36 3 D Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107910
  - 16
    - Defining a table in Excel I have column headings for several columns of data that I'd like to treat as an Excel Table, not a pivot table, just a standard Excel table. What steps does one take to define a block of data as a table? Is it done by simply naming it? My thanks for any assistance here. Brad Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107907
  - 17
    - Hyperlinks Is there a way in excel to turn off the hyperlink feature for an entire column of data? I have a column of email addresses, and I don't want any of them to be an active hyperlink. I can remove the hyperlink individually, but have not been able to find a way to do it for the entire column of data. Thanks! Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107906
  - 18
    - Duplicate Values I have a spreadsheet that has 3000 entries and I have a coloum called SBS_No only problem is that I think I have duplicate entries as the SBS_No is unique. Is there anyway that I could get excel to point out any duplicate values. Like returning value false if it is a duplicate value. Fiona Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107905
  - 19
    - HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C7032B.0406A590 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello! Sheet 1 contains the raw data. Sales and cost of sales for customers.=20 Sheet 2 contains the pivot table that summarizes the data in sheet 1.=20 In Sheet 3(a further summary of the Pivot Table), I would like to put in = the customer name and extract the related sales and cost of sales = numbers from the pivot table. How can I extract the desired information? Regards SJ ------=_NextPart_000_0006_01C7032B.0406A590 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Arial Narrow" size=3D2>Hello!</FONT></DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2>Sheet 1 contains the raw data. = Sales and=20 cost of sales for customers. </FONT></DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2>Sheet 2 contains the pivot = table that=20 summarizes the data in sheet 1. </FONT></DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2>In Sheet 3(a further summary = of the Pivot=20 Table), I would like to put in the customer name and extract the = related=20 sales and cost of sales numbers from the pivot table. </FONT><FONT=20 face=3D"Arial Narrow" size=3D2>How can I extract the desired=20 information?</FONT></DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2>Regards</FONT></DIV> <DIV><FONT face=3D"Arial Narrow" size=3D2>SJ</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C7032B.0406A590-- Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107904
  - 20
    - Importing External Data - Error Only One Column Imports I want to import data from on excel spreadsheet to another. I have been using the Import External Data feature with no issues. Currently, I am attempting to import an excel spreadsheet that is only about 20 columns in length and about 250 to 500 rows. When I complete the the import command it ONLY imports the first column and nothing else. Does anyone have any suggestions, insights, or comments on what could be causing the problem and what some poosible solutions may be. Thank you Ed Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107903
  - 21
    - Drop Down Lookup Return Value From Another Cell Greetings! I would like to have a drop down pick list that returns the value from an adjacent cell instead of the one picked. For example, I have a list of Units of Measures in one column and their abbreviations in an adjacent column (i.e. "hundred weight" in cell b2 and "CWT" in cell a2) I would like to have the drop down list displaying the long description in column B to pick from but return the abbreviation from column A. Can not figure it out, what am I missing? SM Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107902
  - 22
    - Macro Issue File Locked for editing Have set up an Icon on Toolbar with a standard Macro which I like to use. But each time I open a new Excel get a message if have multiple instances of excel open.. FILE IN USE. PERSONAL.XLS IS LOCKED FOR EDITING Also How do I respond to a reply to a question placed on this website .... EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107901
  - 23
    - Retrieve text from column Hi. I am wondering if the following is possible and if anyone could assist.... I have data that I am pasting into excel (a1). I cannot adjust the data (using text to columns) as the data may be in different places but always on the same row. Example: All of the following data will be in one column (a1).... Name Joe Blow Sr. Address 1234 MIckey Mouse Lane #4 City Nowhere State Florida Co Name Cold Sizzlers Phone (555)555-4321 I am lookin to retrieve the next 14 characters after the word "name" is found. I am looking ot retrieve the next 12 characters after the word "State" is found. etc.... Ultimately I want to search one column for a keyword and retrieve the x number of characters afterward. Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107897
  - 24
    - Query Howe do I start running a macro? Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107896
  - 25
    - How do I add favorites for Excel 2003 users on a terminal server This is pretty important to my users. In 2000 it was there by default (File>Open on the left hand side the big icons). How do I get the same thing to happen in 2003? There are several files that they only use once a month that have monster long UNC's to access. I'd really like to get this fixed. Tag: 100% CPU usage for 1+ minutes during save and print preview Tag: 107895

I am running MS Excel XP (2002) with all the latest updates.

When I open any speadsheet and either save or print preview, the CPU
spikes to 100% and it takes at least 1 minute for the operation to
complete.

What could be causing this?

Top

RE: 100% CPU usage for 1+ minutes during save and print preview by CLR

CLR
Fri Nov 10 09:04:02 CST 2006

Perhaps a macro causing it to save itself, or possibly tring to retrieve
other external data..........

hth
Vaya con Dios,
Chuck, CABGx3

"Matt" wrote:

> I am running MS Excel XP (2002) with all the latest updates.
>
> When I open any speadsheet and either save or print preview, the CPU
> spikes to 100% and it takes at least 1 minute for the operation to
> complete.
>
> What could be causing this?
>
>

Top