disable Compatibility Mode in Vista for Excell

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- 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
    - date format help needed please sorry to post twice- but not sure where this question belongs...I have a column of mixed format.... some numbers and some are brought in as numbers stored as text. I need to apply a date format of mmddyyy however, when I apply to column, the values that were numbers stored as text display the error code: ########### and the pop up tip reads "dates and times that are negative or too large display as #######". I have tried formatting the numbers stored as text into number values before I apply the date value, but excel drops the leading zero's and that is unacceptable for the reports I need to submit. Any help would be greatly appreciated.... Thank you very much. Candice Tag: disable Compatibility Mode in Vista for Excell Tag: 808671
  - 2
    - Find/Replace Problem Excel 2007 stopped highlighting the row/column/cell when using the Find function having preselected a group of columns or rows or the entire worksheet. It finds the value entered but does not highlight it on my screen. This was working OK before the last release on August 14th. Is this a bug or does anyone know a solution or workaround? Tag: disable Compatibility Mode in Vista for Excell Tag: 808669
  - 3
    - How do I print Excel file properties information? I would like to print Excel file properties like it is possible to do for Word documents to show date created, saved, etc. Is there a way to do this? Thanks for the help. Tag: disable Compatibility Mode in Vista for Excell Tag: 808659
  - 4
    - Lookup Data Across Multiple Worksheets I need the ability to look data across multiple worksheets. In essence, I need something like VLookup or HLookup, but I need a 2-dimensional search across (a) a given row or column on one worksheet and (b) the same row/column in each worksheet in a defined group --, rather than 2-dimensional across a row and column, as in VLookup and HLookup. Any ideas? Tag: disable Compatibility Mode in Vista for Excell Tag: 808656
  - 5
    - Choose the cells where there is a value Hi all, I have two columns where there is a value in one of them ( column for negative & the other one is positive ) I want to have a third column shows the values of the 2 columns before, as I have 500 rows to look at. Can any one help on this. Thanks in advanced. Regards Tag: disable Compatibility Mode in Vista for Excell Tag: 808651
  - 6
    - Pivot Tabe Duplicate Grand Total Good Morning All, XL2007 I have a basic PT summing vales across a row of months. A B C D Overheads 10 10 10 Expenses 20 20 20 Grand Total 30 30 30 Now I wish to insert another Grand Total Row which will show the Running Balance ie A B C D Overheads 10 10 10 Expenses 20 20 20 Grand Total 30 30 30 Grand Total(2) 30 60 90 I know I could add a seperate row outside the PT to reflect the Running Total, but would rather keep it included, via a Calculated Field or such like. I have managed to contrive a Calculated field, but this returns Subtotal rows for the Running Balance for all my Subdivisions, eg Overheads, Expenses etc. I wish just the Grand Total(2) to show the Running Balance. Is there a way? As usual thank you for any input. Cheers Mathew Tag: disable Compatibility Mode in Vista for Excell Tag: 808645
  - 7
    - what are the thick black lines called that outlines a cell? when you click on a cell it puts a thick black line around the cell.......what is that called and can the color be changed? Tag: disable Compatibility Mode in Vista for Excell Tag: 808640
  - 8
    - Setting all users to save Excel 2007 files in 2003 format Hello gang I have found the regkeys to set the current user to save in 2003 format but I need to know how to do this for all users. Can someone point me at the solution if there is one? -- OMK Tag: disable Compatibility Mode in Vista for Excell Tag: 808639
  - 9
    - Compare and merge in 2007 I have a shared workbook which was distributed to 3 different users to add information into. Information from User 1 can be merged into the 'master' spreadsheet successfully. Changes made by User 2 & 3 will not merge and no errors are received. Tag: disable Compatibility Mode in Vista for Excell Tag: 808637
  - 10
    - Print on both sides of paper from two worksheets How do I get a printer that will print on both sides of the paper automatically to do so from two worksheets in the workbook. If I have two pages on the same worksheet it works fine or if I print to a printer that requires the paper to be changed manually it works fine. But it the printer handles the paper automatically it gives me two sheets with the back side blank. Thanks -- SC from Lubbock, Texas Tag: disable Compatibility Mode in Vista for Excell Tag: 808627
  - 11
    - Embedded file A pdf file can be embedded into a work sheet by the Insert/Object menu. When the icon/control so produced is clicked the file opens with Acrobat Reader which is fine. There seems to be no way to prevent the user from moving or even removing the link. The file could also be opened with a hyperlink but that means the user has to ensure the file is maintained in a standard place. Is there a solution that is user proof? TIA Henry Tag: disable Compatibility Mode in Vista for Excell Tag: 808619
  - 12
    - Hello from GPx Hello from GPx - GlobalPost Extrem -- JTScofield Tag: disable Compatibility Mode in Vista for Excell Tag: 808618
  - 13
    - HOW DO I E-MAIL WORKSHEET AS IS WITH ALL FORMULAS, ETC? Trying to e-mail a financial worksheet and only print out sent, not the sheet in the workbook with formulas, etc. Is there a way to do that? When I click the Office Button and go down to send, only choice there is "Inernet Fax". Tried "e-mail" under commands and only print of sheet without the "guts" transmitted. Thanks Tag: disable Compatibility Mode in Vista for Excell Tag: 808616
  - 14
    - adding commands to Quick Access toolbar Dear for Excel 2007. how can i add the following commands to Quick access toolbar: Home>Font> Superscript and Home>Font> Subscript i was trying to find them in the list of (all commands) but i couldnt find them :-( if there is no such a commant to add to the toolbar what is the keyboard comand for it? any help please xx Tag: disable Compatibility Mode in Vista for Excell Tag: 808615
  - 15
    - Opening a password-protected spreadsheet from a website link Is it possible to open a password-protected excel spreadsheet from a link on our website? What I am trying to do is permit people with the proper password to access the file from our web site link. When you click on the link to open the file, doesn't even open the dialog box asking for the password. Is there a way I can get Excel to open the password dialog box rather than just refuse to open - period? I use Yahoo Sitebuilder as my website builder - if it makes a difference. Thank you! Tag: disable Compatibility Mode in Vista for Excell Tag: 808614
  - 16
    - How to link to Excel Sheets Together Greetings, Can I get feed back on how to link information on two excell sheets. I have information on two sheets. The information basis is the ID number, but I need certain information to be included in both sheets or make a new sheet that combines the information of both by using the ID to link them both. Thank you. -- Grace -- Grace Tag: disable Compatibility Mode in Vista for Excell Tag: 808611
  - 17
    - Help with a formula please? I have a spreadsheet which contains rows of client data. The clients at the top of the sheet are the active clients, and are separated from those at the bottom (non active) by a blank row. Can anyone help me with a formula which will give the number of active clients i.e. by identifying the row of the topmost blank cell in column A. Many thanks, V Tag: disable Compatibility Mode in Vista for Excell Tag: 808604
  - 18
    - Need to pick up data from left of a space starting from the right? 1 4210210 134.40 2 30362920 395.40 3 820401-2 116.20 4 728435514 5152.06 5 820401-1 194.57 6 820501-1 365.90 7 42111438 1158.50 I need to find the space from the right to left then bring back left of that mark to the right. Should look like this: 134.40 395.40 116.20 5152.06 194.57 365.90 1158.50 Thanks Tag: disable Compatibility Mode in Vista for Excell Tag: 808603
  - 19
    - Non-Contiguous Named Range? Hi - I've created one dynamic named range to hold all values from cell D2 to last cell in column (so if user adds another value to bottom, named range extends automatically to include that value). Now, I'd like to create another named range which is a subset of the main named range ... this subset would include all values which start with "escrow". Is there a way to build a named range like this? The values won't necessarily be contiguous (ie, user adds a new 'escrow' value to bottom of column and doesn't re-sort the whole list). Thanks, ray Tag: disable Compatibility Mode in Vista for Excell Tag: 808599
  - 20
    - Rearrange data into other columns I have a spreadsheet I use to assign our committee audit areas. The same group of people is rearranged and put into the other columns (per month). It is rearranged in no particular order, but I attempt to ensure that the same person does not have to audit the same area two months in a row. Currently, I manually create this. It looks similiar to this: Area to audit May June July ... East Side Nancy West Side Ann South Side Joe North Side Jamie Office Ruth Metals Sherry Warehouse Becky Is there a way to rearrange the data for each month so that I'm not spending hours attempting to ensure that everyone is seeing each area? Tag: disable Compatibility Mode in Vista for Excell Tag: 808598
  - 21
    - Formula for formatting font/style Hello! I am creating a spreadsheet where, in a certian column, each entry starts with a bold capital letter that codes for something, followed by a text description. I am hoping a formula or setting exists so that I can type my information in and automatically capitalize and bold the first letter, then keep the rest unbolded. Is this possible, and if so, what's the formula? Thank you! Tag: disable Compatibility Mode in Vista for Excell Tag: 808593
  - 22
    - PivotTable - Sum and Count As part of my PivotTable, in the Data field I have 2 columns, one for the Sum of a value and one is for the count of another value. The PivotTable displays what I want, each on a row, but I would like the currency sign to appear on sum values but not of course on the count values. I tried clicking on the Sum column in the data table and changing it to a number using the PivotTable field option but it doesn't stay. Is this possible to do? Tag: disable Compatibility Mode in Vista for Excell Tag: 808590
  - 23
    - X EQUALS A NUMBER I would like to place an x in a cell and it repesents a number: For example: Always Frequently Occationally Seldom Never =1 =2 =3 =4 =5 Only one x per row. There are several rows with questions and each answer needs to be represented with an X and the X needs to have a value. Tag: disable Compatibility Mode in Vista for Excell Tag: 808581
  - 24
    - Format row color based on individual cell I have a list of work orders. In column G, they are listed as being one of four types, A, b, c, or d. I would like row 1 to have a background color based on the type in column g. I would like to do this throughout the spreadsheet. I have tried conditional formating, but I haven't been able to get it to work. Thanks for your help. Tag: disable Compatibility Mode in Vista for Excell Tag: 808574
  - 25
    - contact list I already have a contact list made out that has 3 rows and I print it out when I'm done adding/deleting. Everytime I add a new contact it moves the list down off the page and I have to manually move each contact to the top of each list. I want it to automatically move it to the top of the next list. Tag: disable Compatibility Mode in Vista for Excell Tag: 808570
- Next
  - 1
    - Sorting Pivot Table by Total Does anyone know if there is a way to use the Grand Total column of a pivot table to sort data in decending order? Tag: disable Compatibility Mode in Vista for Excell Tag: 808566
  - 2
    - Select, find in another book, copy, return and paste Excel 2003 I have multiple catalogue workbooks, all use the same layout. I want to update the on hand stock in column H for the item numbers I select in column B. All on hands are in workbook peter1.xls in column G. I have recorded the steps I would like to do with the macro recorder but I want this to work with any cell or range I select in B from any of the workbooks I open. Sub Find() ' ' Find Macro ' Macro recorded 15/08/2008 ' ' Windows("Beverageware 111 Basic Decorated.xls").Activate Selection.Copy Windows("peter1.xls").Activate Cells.Find(What:="P221558", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Range("G1991").Select Application.CutCopyMode = False Selection.Copy Windows("Beverageware 111 Basic Decorated.xls").Activate Range("H8").Select ActiveSheet.Paste End Sub I hope this explains what I need. Tag: disable Compatibility Mode in Vista for Excell Tag: 808556
  - 3
    - Select Wich Cells To Include In Print Good Evening All, Excel 2007. I have a ss (report), in which I have included notes for the user, eg 'click on button to refresh data'. These notes have been placed directly in available cells, (ie are not n a comment). I would like to exclude these note ranges eg D4:F4, (note in D4 but carries over into F4) from appearing in the printed version. Is this possible, or do I have to use a comments box, & then clickon the not to show in print option? Cheers Guys, Mathew Tag: disable Compatibility Mode in Vista for Excell Tag: 808555
  - 4
    - Maximum Allowed Rows I need to exceed the 65536 rows allowed in Excel. My work needs to be saved in the csv format, and it must be a single column. Is there any way I can create a single column with several hundred thousand rows? Tag: disable Compatibility Mode in Vista for Excell Tag: 808554
  - 5
    - Scheduling Functions I'm creating a spreadsheet to track approaching deadlines for tasks to be completed (on a construction project). I'm trying to figure out if there is a function/formula that I can use to highlight cells as the dates approach. For example, if today is 8/15/08, all cells that contain a 8/22/08 date or closer would be highlighted. Any help would be much appreciated. Tag: disable Compatibility Mode in Vista for Excell Tag: 808553
  - 6
    - Using index and match Hi all- Iâ??m, trying to use an index and match function to return text from cells on anther sheet. =INDEX(Formulas!$J$3:$K$6,MATCH(AM7,Formulas!$J$3:$K$6)) The formula looks for a value that matches AM7, it is suppose to return text from cells on another page shown below. I keep getting the dreaded #n/a. I have the text organized in cells Clmn J Clmn K Row 3 4.0 This was out-standing Row 4 2.8 Pretty good but you need ot work on Row 5 1.5 You really need to focus on this more 0.0 No comment here Anyhelp would be very appraciated Cheers George Tag: disable Compatibility Mode in Vista for Excell Tag: 808552
  - 7
    - Issues when trying to print file from Excel 2008 Mac to Excel 2007 The file was created in Office Mac 2008 Excel and when we try to print in Excel PC 2007 it formats the document from 11x17 to another size that is not satisfactory. Can someone help please? Tag: disable Compatibility Mode in Vista for Excell Tag: 808538
  - 8
    - Copy fill I have a large file that resulted from a pivot. Along the first column of the pivot I have cost center text that often looks like numbers but isn't because many of the centers also have letters. In the second column of the pivot I have job identifiers. Now, each cost center in column A may have multiple jobs. I have to do further work on the pivot results so I copied the values into another worksheet. My problem then becomes copying and filling the blanks in column A with the corresponding cost center text. If I grab the fill handle and double-click, the resulting fill assumes the number looking text is numerical and increases each cell by one (when I want to fill the blank spaces with the exact same text). Since my file is very large, this becomes a major pain (I have to highlight the copy-from cell, do control-copy, highlight the range of copy-to cells, and do control-paste). Is there some easier way to do this? Tag: disable Compatibility Mode in Vista for Excell Tag: 808534
  - 9
    - On excel, can you merge the data from 2 diferent cells I import data from another program to excel, and it place the last name on one column and First name on another column. Is there a simple way to combine both without cutting and and pasting. Tag: disable Compatibility Mode in Vista for Excell Tag: 808530
  - 10
    - Stange numbers Hello all, Some one in my office has ask me for help and I could not figure this out. The setup:you have a set of rows with number and those number are formatted with "Accounting" two decimals no symbol. When doing a manual sum or using the AutoSum, whey would my number come out like so â??0.00â?? and not a dash? If you increase the decimal out there is a number, â??0.00000000000000164316543â??. ?? The number are whole numbers, e.g. 24.25, 100.25, 562.64 ect. Thanks Tag: disable Compatibility Mode in Vista for Excell Tag: 808523
  - 11
    - Can I assign keyboard shortcuts for special characters in Excel 20 I work a lot in Excel, using Chinese PinYin (Chinese words using our letters, rather than Chinese characters) - where every single word has at least one character with an accent on it! In Word 2007, you can assign keyboard shortcuts to enter the relevant letter - such as an "a" with a grave accent (CRTL+`,a) or with an accute accent (CRTL+',a). These shortcuts make sense (ie. easy to remember) as they involve the actual letter + something that's on the keyboard, and you don't have to go into the Insert Symbol menu/window each time. You can also assign your own shortcuts to characters that aren't pre-assigned. In Excel you don't appear to be able to use these. Instead it appears that the only way to do this is by going into the Insert Symbol menu. This is very slow!! Even if you pin the menu to your Quick Access Toolbar, it's still very annoying since you have to switch between keyboard and mouse for every single word. And you can't leave the window open whilst you continue with your typing. Can anyone suggest a way I can assign shortcuts and use them in Excel 2007? (Preferably these would be the same shortcuts as in Word, as I won't be able to remember the ALT+0000 number for all the different characters). Help please!!! Tag: disable Compatibility Mode in Vista for Excell Tag: 808519
  - 12
    - Spacing with formulas Hello all, I have the following data. I need to get the first set of data, then the 2nd set and then 3rd. The problem is that the data will not be consistent, as you can see below. Now, the data is gather with a formula, (1st formula) =OFFSET(A1, MATCH("Line#Number AmountReason For Difference",A:A, FALSE), 0, 1,1), (2nd formula) =LEFT(B158,1), then (3rd formula, final) =IF(C158="1",B158,""). I know that you can use â??text to columnâ?? and have it put in the cell next to the original data, but is there a formula that I can use? I would like to avoid using a VB code for this (my user are not to savvy). 1 4210210 134.40 2 30362920 395.40 3 820401-2 116.20 4 728435514 152.06 5 820401-1 194.57 6 820501-1 365.90 7 42111438 158.50 End results is such: 1. 4210210 $134.40 2. 30362920 $395.40 3. 820401-2 $116.20 4. 728435514 $152.06 5. 820401-1 $194.57 6. 820501-1 $365.90 7. 42111438 $158.50 Thanks Tag: disable Compatibility Mode in Vista for Excell Tag: 808518
  - 13
    - Next time sheet is touched, remove items from cells? I had this before and did not get any takers. I think the chalenge is more getting to do it once and not to check each time? ============= Not sure how to do this, but I have a sheet that I have a macro export data and update a field to say processed in cell F5. I want to know if there is a way to remove that if someone does anything to the sheet like update a description or update numbers. This is more a control thing so I know that the file will match the export and if someone updates something on the sheet, then the word "processed" in cell F5 will be gone. thanks in advance Tag: disable Compatibility Mode in Vista for Excell Tag: 808517
  - 14
    - Help I used to use F4 for locking the cell or in other words it used to put $45$ around the number so it would not change as you copied it down a range of cells. Now it does printing. How do you change what function does what? Cannot find this anywhere... Thanks... Tag: disable Compatibility Mode in Vista for Excell Tag: 808513
  - 15
    - Should i delete heading/subtotal rows when consolidating? I am ready to try RDB's macro for consolidating several worksheets into one using Excel 2003. 1. In preparing the worksheets to be used for consolidating, do i need to delete rows that are not "data" rows? I would still need them in the final worksheet but more for formatting the report. 2. If answer to 1 is yes, is there any way to automate the report formats in the consolidated/merged worksheet? Thanks greatly! Tag: disable Compatibility Mode in Vista for Excell Tag: 808512
  - 16
    - Days and Dates look up 1/2/2008 VC 2.00 5/21/2008 VC 10.00 5/30/2008 VC 10.00 5/31/2008 VC 10.00 6/21/2008 VC 10.00 6/22/2008 VC 10.00 Is it possible to correlate dates with days by looking up a 2008 calendar? What I am trying to do is find day of the week which corresponds with the date (e.g. 01/02/08 - Wednesday). Thank you Tag: disable Compatibility Mode in Vista for Excell Tag: 808511
  - 17
    - How do I abbreviate words? I am a data modeller and I need to abbreviate business names into column names. I have multiple words in a cell that I have to abbreviate by looking against a dictionary For example I have Invoice Amount and it needs to be abbreviated to inv_amt. I have a worksheet containing 2 columns one with the abbreviation and other with the complete word. How do I write a macro to convert a long list of business names in to abbreviated column names? Any advice is appreciated Regards Tag: disable Compatibility Mode in Vista for Excell Tag: 808509
  - 18
    - data from sheet to sheet automatically Is there a way for me to be able to get data that I input on one worksheet automatically inserted into another worksheet... Ex: I have a yearly budget with the monthly totals, And then I have the monthly budgets with the weekly totals. Can I get it to where when the weekly totals are added up for the month, (Worksheet 1 monthly total) that the monthly total in that worksheet automatically gets inserted into the monthly total on my yearly budget (Worksheet 2 yearly total)? Tag: disable Compatibility Mode in Vista for Excell Tag: 808501
  - 19
    - If Statement Help Hello, My boss needs me to do an IF statment on a spreadsheet. Here is what I need: In the Column "Interest Rate" the cells are percentages 0.00%, 5.50%, 2.25% and so on. In the Loan Type Column are the loan types depending on the Percentage Rate. What I need is this: If Interest rate is 0.00% then Loan Tpye is "Letter of Credit" How do I get Excel to do this if the user enters 0.00% in the interest rate column? Thanks!! Tag: disable Compatibility Mode in Vista for Excell Tag: 808497
  - 20
    - Link Merged Cells From reading the comments here, it looks like the general idea is not to link merged cells but is there any workaround to linking merged cells to merged cells? I've tried to reference the whole range and the top left cell, e.g =Sheet1!A9 but neither work for me. Please give me ideas!It seems so simple but I can't get them linking! Thanks, Orla Tag: disable Compatibility Mode in Vista for Excell Tag: 808495
  - 21
    - Compati Checker - erroneous links warning I copied a sheet from one workbook to a new one where it is the only sheet. Every time I try to save the new workbook (in XL11 format) I get the Compati Checker warning me about links to unopened workbooks - even citing 6 occurences. Problem is that: - Edit Links is grayed out (suggesting there are none) - Connections shows no Connections - manually looked at every cell in the sheet and found no links - Search using Find for "=" found no occurrences in entire workbook How do I 'fix' links that don't exist ? Since I am still getting used to developing in XL12, I don't want to turn off or ignore Compati Checker, but if it's giving me bad info that's a problem and I am losing confidence in everything it tells me. Tag: disable Compatibility Mode in Vista for Excell Tag: 808487
  - 22
    - footers I need to set up a footer in the following way: File Name page # of # Date & Time I use this format in Excel and Word and I cannot get it set up in 2007 version. Tag: disable Compatibility Mode in Vista for Excell Tag: 808486
  - 23
    - Inserting a checkbox into Excel 2003 How do you insert a checkbox in Excel that you can check and uncheck? Tag: disable Compatibility Mode in Vista for Excell Tag: 808482
  - 24
    - General question about 2003 and 2007 VBA in Excel I am currently using Excel 2003. I noticed in buying various book regarding the setup and coding it pretty much the same from 2000 - 2003. However, I have purchase Office 2007 and by reading the forum that 2003 and 2007 and are like night and day (for the most part). My question is this: Before I start buying a bunch of 2007 books, will it be necessary to buy books referring to VBA or is the VBA coding that's used for 2003 the same for 2007? I ask this because I have books showing how to code for example "If" statements. So would I code and "If" statement the same way in 2007? I hope this is not going to be like learning all over again. :o) I know my question may seem like a bit simple but, I just to make sure I know what books I need and which ones I can still use before building another library. :o) Thanks!! Tag: disable Compatibility Mode in Vista for Excell Tag: 808480
  - 25
    - Bold When I bold one word in a cell and then add a new row below the words are also bolded and I have to go back and unbold them is there a way around this so that I don't have to continue to do this? Tag: disable Compatibility Mode in Vista for Excell Tag: 808478

Vista keeps converting my Excel documents to a Compatibility Mode...how does
one keep former documents and the command tool bar from doing this

Top

Re: disable Compatibility Mode in Vista for Excell by Bob

Bob
Mon Aug 18 12:38:50 CDT 2008

Why would Vista do that? Perhaps the issue is your Excel settings? Are
you saving everything as XLS prhaps?

bad vista wrote:

> Vista keeps converting my Excel documents to a Compatibility Mode...how does
> one keep former documents and the command tool bar from doing this

Top