http://help.wugnet.com/office/Setup-forum-40.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office/Excel-error-opening-spreadsheet-Small-Business-Edition-insta-ftopict1039359.html#3730321 By: purvasetia - "Magi" wrote in message news:94b03ed56c9d4783ba9a03af1ab48aa3@newspe.com... > Hi! Did you ever sort out your problem? How? I have encountered exactly > the > same problem. Very irritating > > url:http://www.ureader.com/msg/10401477.aspx http://help.wugnet.com/office/lock-cells-exel-ftopict693957.html#3729830 By: Gord Dibben - You must unlock the contiguous range which you want to filter. You must set the Autofilter to enabled before protecting the sheet with "Allow users to" Use Autofilter. Or you can use code to unprotect, do the filtering then reprotect. Gord Dibben MS Excel MVP On Wed, 28 Oct 2009 05:15:01 -0700, Faiyaz wrote: > > >"funb... http://help.wugnet.com/office/Filter-remove-ftopict1180010.html#3729331 By: Yvonne007 - Use 'Advanced Filter'. 1. Click [Data] tab, [Sort & Filter] Group. 2. Click [Advanced]. 3. Choose [Copy to another location]. 4. Set [List range] to "companies' name scope". 5. Set [Copy to] to "the first cell of result scope". 6. Check [Unique records only]. 7. Click [OK]. "bronxbabe" wrote: > I have a list of names with matching corresponding companies (6,... http://help.wugnet.com/office/dimensions-spred-sheets-ftopict1026570.html#3729319 By: Dr. Hay - The system for row and column dimensions is bullshit. I would guess that maybe 50,000 people in the USA knows that 72 points is an inch and no one knows how many letters of any particular font equals one inch. ord Dibben" wrote: > If you want to use VBA to set height and width in mm. > > Ole Erlandson has code for setting row and column dimensions. > > http://w... http://help.wugnet.com/office/Excel-2007-Basic-Filters-Problem-ftopict1179969.html#3729101 By: Simon Whale - fixed.. we applied service pack 2 and it now works why not sure but it works Simon "Simon Whale" wrote in message news:B1A7B7AE-872A-46D5-9566-D7B3744896CD@microsoft.com... > In Excel 2007 upgrade from Excel 2000. (from a office upgrade to Office > 2007 > Basic) > > The scenario is. Largeish spreadsheet loads ok. on Ap... http://help.wugnet.com/office/Default-date-format-ftopict1179809.html#3728594 By: JP - The workaround would be to format the worksheet with the date format you want, save the workbook as a template (Filename: book.xltx) in your XLSTART folder. Here's a tutorial: http://www.brighthub.com/computing/windows-platform/articles/27366.aspx --JP On Oct 6, 8:53am, "Kevin" wrote: > Our company uses Office 2007 Professional Plus > > How do y... http://help.wugnet.com/office/Add-Ins-tab-missing-Excel-2007-ftopict1054784.html#3728377 By: Shailesh Shah - Hi Bob, Try, Download "Excel Menu-2003" from below website. http://shahshaileshs.web.officelive.com/MenuAddins.aspx Open in excel. You can see Addins Tab having Classic menu inside. Go To menu>View>Toolbar. You can see the list of all toolbars including custom toolbar. If you only see 3 custom toolbars(of this addins), restart excel & again view the toolbars... http://help.wugnet.com/office/uninstall-office-2007-trial-features-expired-ftopict1179701.html#3728085 By: Yvonne007 - Apply [Microsoft Fix it 50154] How do I uninstall the 2007 Office suites if I cannot uninstall it by using the "Add or Remove Programs" feature? http://support.microsoft.com/kb/971179/en-us or Uninstall manually How to manually uninstall the 2007 Office system if you cannot uninstall it by using the "Add or Remove Programs" feature http://support.microsoft.com/kb/9... http://help.wugnet.com/office/text-numeric-field-ftopict1179719.html#3728077 By: Kassie - Select the cells you want to use for numbers. Click on Data Validation. Change the block that says Allow Any value to Allow Whole Numbers or Decimals, depending on what you want, set the criteria to greater than and make it 0 or 0.01. You can only enter those values then, and not any text. Rather, you can type text into such a cell, but when you press , an error ... http://help.wugnet.com/office/display-leading-ftopict1179684.html#3727929 By: Dave Peterson - You could enter your value as text: Pre-format the cell as Text (format|cells|number tab in xl2003 menus), then do the data entry (including the leading 0's) or start your entry with an apostrophe: '00001234 Or you could format the cell to show what you like: Format|Cells|Number tab|Custom category 00000 (or as many 0's as you want to see) 5551scj wrote: ... http://help.wugnet.com/office/File-notification-works-machines-ftopict1068263.html#3727654 By: Stuart Hentze - Have you tried loading the Office 2007 compatibility pack, i was having the same issue with one of my customers and installing that solved it... http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en Posted as a reply to: "File in Use" notification works on some machines, not on others 11-Feb-08 I'm tryi... http://help.wugnet.com/office/Excel-2003-Book-Size-ftopict1179360.html#3726445 By: Gord Dibben - If you hit CTRL + End where does Excel take you? Your used range may be more than what you think. See Debra Dalgleish's site for info and instructions. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Wed, 2 Sep 2009 12:30:01 -0700, SJMP wrote: >Why is a excel 2003 Book with (see below) 493kb? ... http://help.wugnet.com/office/stop-resizing-font-resized-chart-ftopict1179147.html#3725522 By: trip_to_tokyo - When copying into WORD try the following (if you have not done this already):- Edit / Paste Special / make sure Paste is selected / select Microsoft Office Excel Chart Object / OK Chart is now placed into WORD doc. If you now single left hand click anywhere in the chart it will place a double border around it. On the top double line single left hand click ... http://help.wugnet.com/office/Turning-save-backup-file-ftopict970131.html#3724997 By: Dave Peterson - Nothing built into excel. You could create a workbook template named book.xlt and store it in your XLStart folder. Make sure you include all the settings you like in that template. In xl2003, a new workbook will be created based on this workbook when you click on the New Icon on the standard toolbar. For existing workbooks, you could create a macro that you could... http://help.wugnet.com/office/Column-Labels-show-numbers-ftopict1178919.html#3724567 By: Lars-Åke Aspelin - On Wed, 29 Jul 2009 10:36:02 -0700, frenchk53 wrote: >Columns and Rows are usually set up as A1 (for example). Now my columns are >#s as well (Col. 1/Row 1). I don't see where I can change back to the alpha >labels for columns. Can someone help? You might have turned on the R1C1 reference style. Try to turn it off. ... http://help.wugnet.com/office/Copy-Picture-ftopict1177924.html#3724001 By: ebrunner - I have the same problem. Never had it before (even w/0ffice 2007), but over the last few months its been I like to copy my cells regularly (ctrl-c), then paste special (as picture) into the word/ppt doc. The tables usually come out as printed, but now they're coming out as a screenshot.