Data refresh

Hi, in Excel 2000, when you select to do a data refresh 
either by opening the doc or by selecting data refresh, 
is there a way you can protect the formattting style of 
the data I have set-up, eg the font size & style, cell 
size etc. I notice when I refresh it pastes it back 

ludi (1)
2/4/2004 3:00:22 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 51

Hi Ludi
I have found that the only way to overcome this problem is to record 
macro that refreshes the data and then formats as I want it to appear.

I then link the macro to a button of the worksheet. - The 'bonus' i
that you get to refressh the data in one less mouse click

Message posted from

2/4/2004 8:28:59 AM

Similar Artilces:

how can I format output data to a file
How can I format data for output to a file in a particular format ie. 6 chars 25 chars 49 chars from 3 work sheet columns which a not 2,25 and 49 long. This is so that the data can be read by another program. If the first cell only has a "1" in it how do I get excel to output blanks to fill the space to 6 char for the first output? Set your column widths to the field widths you want (6, 25, 49). Set the text alignment for each column to what you want if the default (left for text and right for numbers) is not correct. Then do a File, Save As and pick Formatted Text as the f...

Deleting data entries but not formats
Hi newsgroup, I have some trouble with excel... and with a document which I use for serial mails via Mail Merge. Now I need to clean all old data entries and prepare it for the next use. But if I simply delete the entries or do it via Clear-Entries then I have problems because conditional formatting will also be deleted and furthermore the mail merge cant work anymore because some fields are not found anymore. Does someone know how I can only delete the data entries, nothing else? The Mail merge runs via SQL and I'm not quite good in it... Thanks a lot in advance and a nice weeken...

How do I fit a graph to data?
I work at a non-profit agency. We receive funds on an annual basis for our work, which we distribute under contract to other agencies. The full details aren't important, the main point is the rate of "burn" through the money. We use different mechanisms to ensure that it lasts throughout the fiscal year, such as breaking it up into smaller chucks, etc. I watch the burn rate to see how it is going. I record this on a daily basis in an Excel spreadsheet. Due to business practices with the other agencies, the burn rate isn't a simple linear graph with a negative slo...

Requery / Refresh calculated texbox
Dear friends, On a form I have two textboxes (cbo1 and cbo2). I need to have a formula in cbo2 (eg [cbo1]*10, that will use what I type in cbo1. The problem is that I need by changing the value in cbo1, immediately to have the result in cbo2. e.g. I type 1 in cob1 = 10 will be shown in cbo2, by typing more in cob1, e.g. 11, in cbo2 will be shown 110. This should be done before update? Where shall I use the requery method? Thanking you in advance, GeorgeC You can do this one of two ways: Either Private Sub cbo1_AfterUpdate() Me.cbo2 = Me.cbo1 * 10 End Sub or set the Control Sou...

Pivot Chart Refresh cancels all chart formatting
Hello folks, I am using pivot chart with calculated fields, on which I did some quite sophisticated formatting (combination chart stacked bar / dot plot with secondary axis ; bar & plot area & grid colors ; labels ; axis & chart titles). When I click the "refresh" (!) button to update the data, the chart formatting is lost and the chart reverts to the default formatting (stacked bar chart with all series) Is there any way to "memorize" the chart formatting on a pivot chart ? TIA -- NZ Loss of formatting is a known problem with pivot charts. There's inf...

adding new columns sheet with external data
I have a excel sheet that I import data from a external database and then i added columns to the sheet that have entries made by me. When the data refreshes if the data is no longer coming from the external it leaves the data that i entered still there. I want it to delete the whole row and leave no data at all external or internal for that line that now does not exist can this be done? ...

Help with a formula to determine data presence in other worksheets in the same workbook
I have a workbook with 20+ worksheets in it. Each worksheet contains a series of columns where generally the 'key' (not a real key but the term will suffice for this example) is in the first column and various attributes of that key exist in subsequent columns. I have a summary sheet as the first one and what I want is a base formula that will tell me if the value I'm looking for exists in a target worksheet (the 'key' column) and if it does, does the value in one of the subsequent 'value' columns match some pattern. I have searched around but I don't really ...

Populating XML data
Hi Guys, I'm fairly new to Powershell (and XML) and have come across a stumbling block that I can't resolve. I'm trying to write some code to poulate an XML file with data about sites within our organisation. This issue is with the nested nodes (I think they're called nodes?) The XML which I hand wrote looks like this: <?xml version="1.0" encoding="ISO-8859-1"?> <Organisation> <Site> <Code>MEL</Code> <Name>Melbourne</Name> <MailServer>MAILSRV1</MailServer> <State>VIC</State>...

Import data from the web
I am trying to import large amounts of data from the web onto a spreadsheet. After about 200 updates, I start getting an error message that indicates the site and then informs me that "the connection to this internet site took longer than the allotted time". I assume this is because I am hitting the site too many times in a few minutes. IS there any way to fix this? Can I put some sort of spacing line into the spreadsheet so that it gives the site a break? Thanks take a look at ENBLEEVENTS -- Don Guillett SalesAid Software Granite Shoals, TX "mi...

How do I get rid of/refresh the browsed pages links in the hyperli
It's driving me nuts just to find one link. Ig I could clear it up once in a while that would be cool. thanks for the help. :) In Internet Explorer, tools, Internet Options, delete files. -- Mary Sauer MSFT MVP news:// "adumbledore" <> wrote in message > It's driving me nuts just to find one link. Ig I could clear it up once in a > while that would be cool. thanks for the help. :) ...

Graph Data Values
I am trying to create a pick and mix graph that shows forecast spen against actual spend by a selected business area. I somehow want to create a graph on the fly based on the selections fo example: If I choose company one and want to see the contracted data I want th graph to pick up the forcasted contracted Labour, Passthru and Othe and show the combined contracted actuals; See attached; and if i then choose company 2 then graph will pick up the releven ranges? HELP!! Attachment filename: Download attachment:

Error when trying to save data
Hello, This is a new CRM install on a Windows 2003 server. The problem is an error whenever we try to save any data. When checking from the server looks like this: Server Error in '/' Application. A potentially dangerous Request.Form value was detected from the client (crmFormSubmitXml="<systemuser><firstna..."). Description: Request Validation has detected a potentially dangerous client Can someone please send out the fix information "In detail" including links, and locations of files? Thanks, Mark Microsoft CRM is not designed to run on server 2003. ...

Filling cells with Serial Port Data
Hi All Anyone know how I would go about filling Excel spreadsheet cells with data from the serial port? Thanks "Funster" <> wrote in news:z%oWb.9627$ > Anyone know how I would go about filling Excel spreadsheet cells with > data from the serial port? probably one of the first results on will tell you what you want -- My email address has an extra @ (spell it out) and an extra invalid. Please remove them if you are not a spammer or list broker and ...

Excel 2007, Sort data by no. similar entries?
Is it possible with Excel 2007 to sort data by the number of similar entries within a column? I.E Row1 Row2 1977 Andrew 1980 Andrew 1960 Rachel 1950 Rachel 1940 Rachel 1965 John What I want to be able to do is sort data in Row2 so that Rachel shows 1st as she has 3 entries, then Andrew and finally John as he only has a single instance, is this possible? Thanks, Andrew. How about using a helper column? I read your row1 as column1 and row2 as column2, and put the formula like "=COUNTIF(B$1:B$6,B1)" into C1 and copy it down to C6. then , sort the table b...

How to Select large amount of data in a colum that equals column from another table.
Ive got a huge table and I want to select the data in one column that is equal to that of a column in another table? is there an easy way to do this? Thanks One way, if you know the parameters of the original, is to type the references in the name box and hit <Enter>. For example, click in the name box and enter: E1:E65000 Then <Enter>. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Jennifer Burnel" <> wro...

adding lines to added data
I have added data to an existing worksheet but when printed the row lines and column border lines do not show. How do I add the lines to the added border to match the existing lines? ...

Insert sheet, move to end, rename with cell data.
I've spent most of my day trying to ask VB to do this for me, but don't know how to communicate it correctly. I have column A in "List"(Sheet1) with 150 entries. I want to create 150 sheets with Sheet numbers of 2-151. However, I would like for the tabs to read what the appropiate cell in "List" says.... ie if +++ (column A) ___ Fun Not Fun Cool +++ was my column, I would like the first four tabs to read "List" (my original sheet), "Fun", "Not Fun", and "Cool". Then they would appear in Microsoft Visual Basic as Sheet1(List...

vlookup help linking data between worksheet
hi, I have a master list of students (about 200+ )in one worksheet. On the succeeding worksheets are the attendance for seminars. We have more than 20 seminars in a year. Because of the large no of attendees per seminar, I usually type out a list of the students who came for each seminar, so there will be 20 +attendance worksheets. Not all students will come every time and there are new ones for each session. To update on master list, I will sort each sheet by surname, print it out and type in separate column (date) for each session and typed "P" for present and &quo...

How do I chart the same data cell on a range of worksheets?
I have the same row of cells on numerous worksheets that I want to chart or consolidate onto another worksheet ? Keith - You need to create a consolidated data range: - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions _______ Keith wrote: > I have the same row of cells on numerous worksheets that I want to chart or > consolidate onto another worksheet ? ...

Dynamic range (column); include only rows before blank row above more data
Hello: One worksheet will contain more than one table holding lookup values (prices, CPU speed, etc.). They will be located one on top of another, with possibly some other data between tables, separated by at least one blank row. They will be expandable by row, as new prices, CPUs, etc. are added. I want the range name to expand and reflect all the rows in a table. Using a column as an example of tables, a (in A1) b c d e f represent 2 tables (ranges). Excel Hacks has the code for Define Name "Refers to" as =OFFSET(Sheet1!$A$1,0,0,MATCH("*",Sheet1!$A$1:$A$100,-1...

Export data to txt format file
Can I write a VB procedure that will export a table of data with specific widths? I done it manually, but no success with VB procedure -- pad On Thu, 3 Dec 2009 19:36:01 -0800, paduanow <> wrote: >Can I write a VB procedure that will export a table of data with specific >widths? I done it manually, but no success with VB procedure Take a look at the Help for "TransferText". Yes, you can create an output specification with fixed width files, in code just as you can using File... Export. -- John W. Vinson [MVP] ...

Accountextensionbase missing data ? Help
Hi I have a customer who has moved CRM 3.0 to new server by them self and I have converted it to CRM 4.0 Now they have made some custom fields and we are able to save data in these fields on new accounts but not on the old ones. We can save data in the old fields. I then took a look at the database and there is only fields in the accountextensionsbase since after they moved the database. How can I fix this ? They can merge each to a new customer but that would take a long time. Can I do a insert into with data from the Account table or is there another solution ? ...

Export Data from MS-CRM
Is there a way to export all of the data from MS-CRM? Thats a rather general question, mean export to another CRM system or just export into another medium? For the most part, most areas have that little excel icon so that you can export into excel...... or you can go into the SQL server and use the export wizard, although I don't think its going to be what you want,....for the most part it will be raw data and you'll have to recreate the relationships and primary fields to see how the objects relate.......... -Gary "John O'Keefe" <

Why does the pivot table not allow me to group data?
I need to group the data in a pivot table, why will it not allow me to? If the field in the source data contains blank cells, or cells with text, you won't be able to group the data. There are some suggestions here for fixing the problem: Forrest wrote: > I need to group the data in a pivot table, why will it not allow me to? -- Debra Dalgleish Excel FAQ, Tips & Book List The tip did not help however, since you wrote the book, literally, let me explain what I need to do. I need ...

Why is the data pulled down from an online update, ALL WRONG?
I'm using Money 2004 Deluxe. I just figured out how to get online updates for my 403(b) from Fidelity. I've pull everything down into MS Money. Looked cool, at least for a while. Then I noticed that out of the 6 mutual funds I'm investing in, only 2 had symbols associated with them. So I tried to assign the symbols to the other 4. Only thing is when I did, I got error messages saying that the symbol was already in use. So then I went into help and found that if I went to the Investing menu option and choose "Work With Investments" and then choose "Choose ...