Copying (and protected worksheets)

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
    - Copying and pasting tabular text data In previous version of Excel when I copied tabular text data from an email it did not automatically merge some of the adjacent columns and word wrap some other fields. How can I disable this "feature" in excel 2007? Tag: Copying (and protected worksheets) Tag: 802090
  - 2
    - Combine 6 worksheets into 1 worksheet - Summary I have 6 worksheets from Jan, Feb, Mar, Apr, May, Jun that have different information on each worksheets. And would like to have another worksheet that would combine all the different codes (over @120 lines) with the appropriate dollar amount for each cityand 0 dollar amount if there's no amount for that month for that code. For Example - Jan Code Atlanta Chicago Detroit 300 - Bill Expense 359.23 234.23 1132.32 301 - Process Fee 65.00 45.00 50.00 400 - Bill Expense 4560.00 333.22 232.32 Feb Code Atlanta Chicago Detroit 300 - Bill Expense 490.20 939.30 1239.33 301 - Process Fee 75.00 55.00 60.00 302 - Sales 3333 4444 5555 400 - Bill Expense 2341.50 267.92 403.72 and so on Summary Jan Feb Jan Feb Jan Feb Code Atlanta Atlanta Chicago Chicago Detroit Detroit 300 - Bill Expense 359.23 490.20 234.23 939.30 1132.32 1239.33 301 - Process Fee 65.00 75.00 45.00 55.00 50.00 60.00 302 - Sales 0 3333 0 4444 0 5555 400 - Bill Expense 4560.00 2341.50 333.22 267.92 232.32 403.72 Tag: Copying (and protected worksheets) Tag: 802088
  - 3
    - Custom Cell Time Format Greetings, I am looking for a custom cell format. I want to type in a number with or without a decimal and have it show as hours and/or minutes. Anyone know how this done? Any help would be appreciated. -Minitman Tag: Copying (and protected worksheets) Tag: 802086
  - 4
    - Excel lack of compatibility How come i am having such a hard time keeping excel 2007 from crashing. Any time i am using .xls files or a chrat or have more than one file open that uses a circular reference it just dies. WTF. This is supposed to be easier to use, more friendly, more stabile, but i have found it to be the opposite. However i have been using it long enough i am proficient with the ribbon and have almost forgotten how to use 2003. But i can't work if i crash it all the time, plus simple things like changing the decimal place of a chart label can't be done with the tools anymore you have to open the axis open and format it. WTF would the make it less functional than the already had it. I would like to combine 2003 with the ribbon of 2007. but that isn't going to happen. So maybe some one can tell me if i am missing something and how to get more functionality out of office 2007 instead of less. Also if anyone has some insight into keeping Office from exploding any time i try to use an iterative calculation, have a chart with more than 10 points, or use older .xls files at the same time. Plus when i work on it in 2007 and my boss proofs what i do in 2003 (because he refueses to switch) all the formats and text boxes are messed up beyond belief. spend 3 days googling but can't find any help suggestions or solutions. Would had to go back to 2003, but might have to just for a stable system. Tag: Copying (and protected worksheets) Tag: 802084
  - 5
    - auto grouping. In column B I have our part numbers and in column A is our serial numbers. Is there a way I can group the serial numbers with the correspondingpart number with out doing this manually. Not every product number has serial numbers and the products that do may have only one serial number or many serial numbers depending on the quantities. Serial # Product # 104-214100 4243232 4334532 104-214101 104-214103 5342322 Tag: Copying (and protected worksheets) Tag: 802078
  - 6
    - Pivot Table Calculated Field Row - (For Balance Sheet) Good Evening Guys, Excel 2007 & still geting to grips with it after years of 2000/2003! Pivot Table query. I have via MSQuery of Sage line50 managed to produce a balance sheet pivot table of sorts.(so far). I Have current assests (with subtotal) & current liabiities (with subtotal), but wish to insert a caculated row of 'Nett Current Assets', ie the diff of the two subtotals, but above the 'Cap & Reserves' rows. I hope I have not made this too 'accountany', but any help with this calulated row would be most appreciated. Cheers, Mathew Tag: Copying (and protected worksheets) Tag: 802074
  - 7
    - Formula Help! I run a small call center and want to track the status of leads for each individual telemarketer. I can count the total number of leads for each TM using the "Countif " function and the TM's name. I need to count the lead status for each TM as well. For each TM name there would be 5 lead status catagories. I have set up the worksheet columns as follows: lead date, lead Name, Phone, Telemarketer, Lead status. Any Thoughts? Tag: Copying (and protected worksheets) Tag: 802059
  - 8
    - Conditional Formating How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa Tag: Copying (and protected worksheets) Tag: 802055
  - 9
    - Excel - Printing a page that contains an Embedded Word Document I have an embedded Word Document in an Excel Worksheet that is 35 lines long. I can open the Word page and view all of the lines, but I can only get 1/2 of the document to print when I print the worksheet. Any suggestions how I can get the whole embedded document to print when I print the worksheet? -- Thanks for your help JLMHoss :) Tag: Copying (and protected worksheets) Tag: 802051
  - 10
    - How to put save date in the header (or footer) I would like to enter a date in the header (or footer) of my Excel spreadsheet. However, I want it to be the date the file was last saved, not today's date. Is there a way to do this? Tag: Copying (and protected worksheets) Tag: 802046
  - 11
    - Can I write my own help files (.hlp) for Excel workbooks? I have an Excel workbook that needs some instructions with it, and I was wondering if it's possible to write my own help (.hlp) files for the users to use. Tag: Copying (and protected worksheets) Tag: 802045
  - 12
    - Validate if cell use data validation Hi there, Does anyone know how I can validate if a cell is using datavalidation using. I mean using VBA and not by opening the Data validation menu... It seams that whenever there is no validation, the value of all parameters are not set. I've tried to use isnull, isempty... nothing worked... Thanks for your help ! Tag: Copying (and protected worksheets) Tag: 802041
  - 13
    - Excel Macro Can anyone tell me the macro language to instruct the cursor to move over x number of cells? -- RCB Tag: Copying (and protected worksheets) Tag: 802040
  - 14
    - What's the difference between excel 2003 and 2005? Tag: Copying (and protected worksheets) Tag: 802030
  - 15
    - Random Selection I have my 30 students listed in a spreadsheet, I would like to find a way in excel that I can set up a formula that will randomly pair them up in groups of 2. I have them listed like the example below 1 Person A 2 Person B 3 Person C etc. I would like the result of the formula to random pair up the students. Tag: Copying (and protected worksheets) Tag: 802028
  - 16
    - Pivot Table If I have a large database that starts with 1/1/2005, I have a pivot table set up that shows an Assigned Detective, and the total of Offenses he has assigned. This works where I can select the det from the drop down and it automatically gives the total of each offense that he was assigned. Agg Assault 10, Burglary 15, etc. Is there a way I can do this for 2005, and then one for 2006, 2007 and 2008. I need a total for each year by itself. The problem is that this is a worksheet we keep adding to with each line depending on the date. One I have to copy 2005 to a sheet and then 2006, etc? Tag: Copying (and protected worksheets) Tag: 802027
  - 17
    - How do I copy a worksheet in the new Excel? I am trying to copy a worksheet and keep it in the same workbook. I have a set of directions from Microsoft but don't know where the Before List sheet is. I also can't seem to find the Move or copy dialog box. Any suggesstions for this luddite? Tag: Copying (and protected worksheets) Tag: 802017
  - 18
    - Macro To Run Automatically For Any Worksheet Upon Opening Of THe F Hello! Have recorded a macro in person.xls that basically Auto fits the cells to show the full name of each column. Have called it Auto_Open and it should open automatically for any Excel file. The need is as follows. The user team team will double click on a csv file and they have associated csv file types with Excel, would like this macro to run for them and the questions follow. 1) First, prior to distributing the macro to other users, would like to make sure it works but having an issue getting it to Auto Open when any csv file is double clicked, the macro is not running, what might be missing here. Have to go to Tools - Macro - Macros, select Auto_Open and then run it, the macro is not running automatically when the csv file is opened, had assumed that calling it Auto_Open would do this. Currently working with Excel 2003 version. 2) How is the macro, Auto_Open, which was created locally, distributed to other users - possibly share it from a network location or send it to each member of the user team 3) How does a user install the macro so it works for them for any Excel file Have looked at some of the other reponses to similar topics in this forum but not totally understanding it yet. Would appreciate any help. Thanks! Tag: Copying (and protected worksheets) Tag: 802015
  - 19
    - Formula to return column letters In Excel 2007, I need to use the letters of the column that I am in in the formula bar. However, I don't need a particular cell, just the letters. Because of this, the letters do not change as I use Autofill down the row. I am using over 500 columns, so I really need for Autofill to do this for me. Basically, in the formula bar, I have "A" in part of my formula (when I am in column A), but when I autofill, every column still has "A" rather than updating. Is there a formula that returns the column letters of the current position? Tag: Copying (and protected worksheets) Tag: 802012
  - 20
    - How can I hide a formula in Excel 2007 from other users seeing it I'm creating a spreadsheet for other users to enter data in and one of the cells has a formula that I don't want them to see. I've got it to where I can hide it on the first row but when I tab down to the next row it won't let me enter any data. Is there a way to hide the formula in that column without messing up the rest? Tag: Copying (and protected worksheets) Tag: 802010
  - 21
    - Refer to adjacent cells as variables in formula In a large column of data some cells randomly have entries of "no data"- (caused by a comms failure at that time). I'd like to interpolate data for these cells by filling them with actual values in cells either above or below them. Can I create a formula that refers to cells either immediately above or below the cells? My problem is that I don't know how to refer to a cell as 'the cell above this one' or 'the cell below this one', as a variable instead of as a specific cell location. If I do find out how to refer to cells like this I suppose that I'll have to make the full formula an 'If' statement- the logic being: "If cell xx ="No Data" then cellxx = cell above cellxx" Thanks very much for any help, Dominic Excel version: Office 2000 Tag: Copying (and protected worksheets) Tag: 802008
  - 22
    - Save as CSV results in an Excel file!? Windows XP, Excel 2003 I have a user who I am helping remotely. They have a small Excel file - about 12 rows. They do a Save As and select "CSV (comma delimited) (*.csv)" as the file type, then click Save. Oddly, they do not receive the usual warning about "features not compatible...", however the file is saved and appears to be a CSV file with the appropriate extension. When this file is opened in Notepad to check it out, it clearly is *not* a CSV file - all special characters and gobbledegook. In fact, the contents look just like a standard Excel file (XLS). I cannot reproduce this odd outcome on my own system. When I save as a CSV, I get the expected warning and the resulting file looks like a CSV file in my text editor. Is there some setting or option in Excel that would cause this behavior? Something that would save the file as an Excel file even when the "save as file type" is set to CSV? -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: Copying (and protected worksheets) Tag: 802000
  - 23
    - East Asian characters in Excel 2003 worksheet do not print. I have an Excel 2003 worksheet that contains East Asian (Simplified Chinese) characters. Although these characters appear in print preview, they do not print on any of my printers -- only the English characters print. However, the Chinese characters print from Word 2003 documents and from PDFs of the Excel worksheet. My operating system is Win XP Pro. I have installed the files for East Asian Language support. What am I missing? Thank you in advance for your help. Tag: Copying (and protected worksheets) Tag: 801998
  - 24
    - Workbook won't allow me to insert worksheet. How can I add one? Hey. I have a workbook given to me by someone and when I try to insert additional workseets to the workbook it won't let me. The "insert" function is not available when I try to add a new sheet. Any sugestions on how to allow the workbook to let me insert new worksheets? Thanks. Tag: Copying (and protected worksheets) Tag: 801997
  - 25
    - questionnaire template I need a template for the following: Type: Online questionnaire for clients Format: Questions are a mix of Yes/No or multiple choice (some with more than one answer selected from a list) Output: All answers carry a weighting and total points are shown on a sidebar as the client completes the questionnaire The points per question are derived from a control benchmark database (not visible to the client) -- KAS Tag: Copying (and protected worksheets) Tag: 801990
- Next
  - 1
    - How do I put a checkbox with no words? I am making a chart with names down the left column and other catagories along the top. I want to put checkboxes in so people can just check them individually for their cell in that catagory. I am wondering how to put the checkbox in without any words. (such as "checkbox 1") I want to remove the words. Tag: Copying (and protected worksheets) Tag: 801989
  - 2
    - Data Fields in Pivot Table I'm trying to write a macro that will clear all fields in my pivot table including the data fields. I have the following: On Error Resume Next Dim pt As PivotTable Dim pf As PivotField Sheets(4).PivotTables("PivotTable2").ClearAllFilters Set pt = Sheets(4).PivotTables(2) With pt For Each pf In .VisibleFields pf.Orientation = xlHidden Next pf End With The macro above clears all fields except the data fields. Any ideas for what I could add to the macro to make it also clear the data fields? Thanks. Tag: Copying (and protected worksheets) Tag: 801982
  - 3
    - Page numbers appearing across spreadsheet There are large page numbers ie. PAGE 1, PAGE 2 appearing across my spreadsheet - they don't appear on the print out, only on the screen. How do I make them go away? Tag: Copying (and protected worksheets) Tag: 801981
  - 4
    - Macro to Fit AutoShape over Range? It seems to me that inserting and manipulating AutoShapes is incredibly straightforward in Excel, but users of a form in our office have asked if there's a way to more quickly make rectangles that would EXACTLY cover whatever range of cells they have selected. (This is all the more annoying of a request, because most of the users are on Excel for Mac, whose Formatting Palette makes this sort of thing even easier.) Anyway: can a macro be written that will do this? I'm imagining that, after a user left-clicks and drags through any area, that they'll right-click, select the macro from the shortcut menu, and the code will plop a rectangle over the area. (I already have a number of custom options on the shortcut menu, so that I can do that part myself.) I know this is all absurd, but any help anyone can offer would be much appreciated! Tag: Copying (and protected worksheets) Tag: 801978
  - 5
    - Default Save Extension Posted in another excel newsgroup 7/11/08 but no solution: I'm using Office Home and Student 2007 on a Vista Home Premium machine. I'm unable to change the default save extension from xlsx to xls. I can do it on an individual file by file basis but I would like to have the program always save the files to a default extension of xls. I've changed the setting in Excel Options and the setting "sticks" but the program continues to create and save as xlsx. I also have the same problem in Word. Any help is much appreciated! Thanks in advance. Tag: Copying (and protected worksheets) Tag: 801976
  - 6
    - Error message - Errors were detected while saving FILENAME In Excel 2007, when saving a file, we get the following message... "Errors were detected while saving FILENAME. Excel may be able to save the file by removing or repairing some features" If we click continue, it gives us the file selection screen to "save as" Press enter, and we get "The file already exists. Do you want to replace the existing file?" If click "yes", the next message is "No errors were detected in FILENAME. No repairs were necessary" Click OK and it saves the file. I have searched newsgroups, but only find references to TrendMicro AV or MS Livecare possibly causing the problem; neither of which we have. Any help would be appreciated. Tag: Copying (and protected worksheets) Tag: 801970
  - 7
    - Cells not included in formulas I have a summary page that pulls numbers in based on account numbers from a detail spreadsheet. Column A is the account number, Column B is the amount on the detail spreadsheet. Is it possible to do some sort of trace function to see what numbers are not going into the summary worksheet? I haven't had this error before and there is not one amount that comes close to matching the difference from the summary sheet to the detail sheet. Hope this makes sense. Tag: Copying (and protected worksheets) Tag: 801969
  - 8
    - Database problem I have set up a spread sheet to keep a track of my spending. Column A is formatted to dd/mm/yyyy and columns B, C, D, E, & F are my expenses with column G being income and column H being the balance. I am trying to set up a seperate worksheet where a single cell will give me the total spending based upon a calendar month. Many thanks in advance for all those who have helped. Tag: Copying (and protected worksheets) Tag: 801968
  - 9
    - excel spreadsheet compare I looking for something I could utilize that would compare two excel spreadsheets. It would need to compare across all cells and note any changes. There will be text and numbers contained within the cells. I've seen some stuff posted on here, but it compares (I.E cell A1 to cell A1). The excel spreadsheets I'll be reviewing will have adds, updates and deletes. So it needs to compare based on a unique identifier (probably name in first column) and then note if there are any changes. Also, note if the data between the two excel spreadsheets is new or deleted data. thanks for any help you can provide.. Tag: Copying (and protected worksheets) Tag: 801965
  - 10
    - Exporting Quickbooks Data into Excel When I run a report and export it into Excel, the file size is way larger than it should be. It seems like when the file gets imported into Excel, there are thousands of extra lines that don't contain any data. I end up having to copy and paste the data into a new Excel spreadsheet. Does anyone know how to fix this problem? Tag: Copying (and protected worksheets) Tag: 801962
  - 11
    - Form a sublist from a list using lookup I have a table listed as follows: (A) (B) (C) 1) Name Region Age 2) John America 23 3) Lee Asia 42 4) Johann Europe 18 5) Tom America 43 6) Sara America 19 7) Ricardo Europe 37 I am trying to form 3 new additional tables for each of the three regions from this table that lists only Names of people over 30 yrs old (preferrably in a descending order). I thought of using something like =IF(AND(C2>30,B2="America"),A2,""), but instead of "", I would want the formula to look into the next rows until it finds one that fits the region, or if it finds none - then it should leave a blank cell. Otherwise, each of the tables would have many blank rows within, between the rows that are of interest. Any ideas of how this could be accomplished? Thank you very much in advance! Tag: Copying (and protected worksheets) Tag: 801955
  - 12
    - Formatting text within merged cell I am trying to enter a row of data in a cell that does not completly fill the cell and want to hit enter to enter more underneath without jumping to the next cell. Tag: Copying (and protected worksheets) Tag: 801949
  - 13
    - Unprotect workbook Using Excel 2007, how do you unprotect the workbook in an Excel 2003 file. The protect workbook function actually indicates it is not protected, but I know it is. Also, when I try to copy in a new worksheet, it says it is protected. Please help. Tag: Copying (and protected worksheets) Tag: 801948
  - 14
    - Commas drop off of number in mail merge to into Word Does anyone know why when I mail merge using Excel 2007 into Word why the commas drop off of the numbers shown in my columns? Tag: Copying (and protected worksheets) Tag: 801941
  - 15
    - Dating a file. What can I add to a file, that I send out periodically, to date stamp that version of the file? -- Matt S Tag: Copying (and protected worksheets) Tag: 801940
  - 16
    - Protecting Cells from changing or modifying long formulas How do I protect certain cells from being changed by other users because i have a long formula within the cell? The rest of the cell in the spreadsheet they can modify, except those particular cells. Tag: Copying (and protected worksheets) Tag: 801934
  - 17
    - Why does my cell content display as '############'? when typing text into a cell, the cell will display '#######' instead of the actual text I've typed. re-sizing the row/column does not help. Tag: Copying (and protected worksheets) Tag: 801920
  - 18
    - Sorting by name but ignore the word The I have a list of movies and I want to sort them by name then what stack there in. a b Gone with the wind | stack 7 The god's must be crazy | stack 6 Except I want to ignore the word "the" in the title but still have it in the title after the list is sorted alphabetically. Easy to do? Is there a way to hide the word and it will sort OK ? Thanks for any help, Rich Tag: Copying (and protected worksheets) Tag: 801919
  - 19
    - Displaying BOTH formulas and values Is there some easy way to display both the values and the formulas? I want to be able to show the results of the formulas as well as the formulas used in obtaining the cell results. I know I can toggle back and forth by using Ctrl+`, but for what I want to do I now have to display the formulas and copy the sheet as formulas into a new worksheet, then insert columns and copy over the results into adjacent columns of cells. Is there another way of doing this? Tag: Copying (and protected worksheets) Tag: 801913
  - 20
    - Timestamp for changes in any row of cells? Hi, I am trying to set up a timestamp at the end of a row of cells that will enter the current date if any cell in the row is altered or updated. I can only do it at present with one cell, if I use a range of cells the formula doesn't work, not sure why. The formula I use is =IF(R4="","",IF(T4="",NOW(),T4)) If I change the R4 to A4:R4 I get a wrong #Value. I'm running Office Pro Excel 2003 edition with SP3. Thanks for any help. Tag: Copying (and protected worksheets) Tag: 801910
  - 21
    - Place zeros in blank cells I have set up an Excel spreadsheet that will be used to input a variety of data that will be imported into an Access database. The data is all numbers and the reports that I run in Access can't do the calculations on blank cells. There are usually 1500 records that are being imported and there are 9 columns that contain numbers, but not all will have a number entered. What I need to find out is how to setup this spreadsheet to automatically place a zero in all blank cells prior to importing without doing it manually. The last time I did it, it took me about 20 minutes. Tag: Copying (and protected worksheets) Tag: 801908
  - 22
    - Cells won't automatically update --- urgent! Hello, We are having a problem with one of our excel templates at work, and we are on a tight deadline. The workbook is quite large....probably 50 to 80 sheets or so. Most of these sheets have been duplicated off of other sheets. The issue is that we have a bunch of valuation multiples linked to an assumptions page, and when we change the number on the assumptions page, the multiples do not update through out the template. We have tried a number of things. We have verified that the cells are set to automatic update in the options menu. We have also tried to go into a worksheet select all and hit F9, which you would think would update the cells. I have also, click on the specific that i want to update and hit F9, and nothing happens. The only way I can get the cell to update is if i put my cursor inside the cell, and hit enter. There is no way that I can go through every individual cell and update them manually like this. Plus we would not be too confident in the integrity of our template. I would consider myself a fairly advance user of excel, and I am quite familiar with using macros in visual basic. If anyone has an easy solution or a set of code that I can run that will update the template for me that would be much appreciated. Thanks in advance!! Ryan Tag: Copying (and protected worksheets) Tag: 801906
  - 23
    - Count I have a large spreadsheet dating back from 2006, is there a way I can search by a Detectives Name which is in Col K and then count the assigned offenses in Col G, example: Detective John Brown col k and then search col G, AA (Agg Assault) and give me a total for Agg Assault, then change col G for Burg (Burglary) and give me a total for Burglary, etc. I have been counting by doing a filter, but I felt there could be an easier way. Thanks, Tag: Copying (and protected worksheets) Tag: 801904
  - 24
    - Print Landscape/Portrait based on level of grouped data selected Probably not possible....but I have a spreadsheet I send to multiple clients where the rows are grouped on levels 1-5 (5 being the most specific of the data, therefore most rows). I have set up buttons (macro assigned) which they can use to print just their columns of data. The titles to the left of the data are repeating, so each individual macro is simply selecting the appropriate columns, setting print area, and printing. I find that levels 1, 2 & 3 of data look best when printed in Landscape. Levels 4 & 5 look best when printed in Portrait. Is there something that I can add to a Macro in order for it to print Portrait/Landscape based on the level of grouped rows selected? Thanks! Tag: Copying (and protected worksheets) Tag: 801902
  - 25
    - Integrity of Column Headers I have created a company form in Excel. The form has several columns and each column has a one, two or three line column header. The form was designed to be viewed at 100% Zoom (the viewing tool in the Standard toolbar). Apparently some form users are viewing the form at 50% or 75%. When viewed at less than 100%, the lines in the column headers break in odd places, for example, when the view is reduced, the one-line header "Quantity" breaks into two lines: Quantit y and the two-line header "Catalog Page No." breaks into three lines: Catalo g Page No. Other than increasing the size of the cells the column headers are in, is there a way to freeze the headers so this odd line breaking won't happen? I tried un-selecting "Wrap Text" in the Format Cells/ Alignment/Text Control menu and this made the headers be one line and the entire header wouldn't display in the header cell, so that wasn't the answer I'm looking for. Can someone help, please? Thank you for your help with my question. Leslie Tag: Copying (and protected worksheets) Tag: 801900

I frequently copy the first worksheet of data into two or three other
worksheets, and then I protect the original data in worksheet1.

Today, for some reason, when I try to copy other cells from worksheet 4 to
worksheet 5, Excel just copies all the data from worksheet1 again. I don't
know if the clipboard is not being emptied, or what.

Any suggestions?

Top

Re: Copying (and protected worksheets) by Tim879

Tim879
Tue Jul 22 19:29:26 CDT 2008

You can manually clear the clipboard by going to Edit-> Office
Clipboard. Not sure if that will help though. Try just restarting
excel.

On Jul 22, 6:20=A0pm, ManhattanRebel
<ManhattanRe...@discussions.microsoft.com> wrote:
> I frequently copy the first worksheet of data into two or three other
> worksheets, and then I protect the original data in worksheet1. =A0
>
> Today, for some reason, when I try to copy other cells from worksheet 4 t=
o
> worksheet 5, Excel just copies all the data from worksheet1 again. =A0I d=
on't
> know if the clipboard is not being emptied, or what. =A0
>
> Any suggestions?

Top