Revised data fails to be used by formulas

I have a spreadsheet doesnt re-calculate the formulas when 
data is changed. It reacts as if I had not selected to F9 
or auto to calculate. I have tried changing the 
calculation option between manual and auto but neither 
selection works. Manual calculation doesnt work either. 
The only way to have the formula work is to select each 
cell as if to edit and push enter.

Several people in my office have started having the same 
problem but only on some workbooks. We all use Excel 2002 
and work on a LAN.

Any Ideas?
0
rholbrook (1)
5/14/2004 10:24:19 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
540 Views

Similar Articles

[PageSpeed] 7

Were your values pasted in? Often that results in values which are 
entered as Text, so some functions (e.g., SUM(), AVERAGE()) ignore them.

Try copying an empty cell, selecting your values and choose Edit/Paste 
Special, and select the Values and Add radio buttons. This will coerce 
any text "numbers" to numeric.


In article <d52e01c43a02$33249e80$a501280a@phx.gbl>,
 "Richard Holbrook" <rholbrook@progressenergy.com> wrote:

> I have a spreadsheet doesnt re-calculate the formulas when 
> data is changed. It reacts as if I had not selected to F9 
> or auto to calculate. I have tried changing the 
> calculation option between manual and auto but neither 
> selection works. Manual calculation doesnt work either. 
> The only way to have the formula work is to select each 
> cell as if to edit and push enter.
> 
> Several people in my office have started having the same 
> problem but only on some workbooks. We all use Excel 2002 
> and work on a LAN.
> 
> Any Ideas?
0
jemcgimpsey (6723)
5/14/2004 11:53:25 PM
Reply:

Similar Artilces:

XML to XML Using XSLT
Hi, I need to transform one xml document into a second xml document. They both have many nodes so xslt works fine, but there is one node I have not figure out how to transform. Here it is: Node in Input File. <FullAddress>JOHN SMITH@19495 BISCAYNE BLVD@MIAMI@FL/33180@USA</FullAddress> The Result should be: <Name>JOHN SMITH</Name> <Address>19495 BISCAYNE BLVD</Address> <City>MIAMI</City> <State>FL</State> <ZipCode>33180</ZipCode> <Country>USA</Country> It seems to me I have to "Split" or "Par...

How to check if mouse wheel has been used, system-wide?
Hi! I have the following task - I need to check time to time if mouse wheel has been used by the user, in ANY application. I have some kind of user activity detector, to do certain actions in application when user is idle for some time. It would be nice to have the ability to check if mouse wheel has been used. I already know how to check for keyboard (GetKeyboardState and compare with previous call's result) and mouse (GetCursorPos and compare with previous call's result). I know how to set up a hook, and can achieve what I need via hook. But, customer says sometimes system runs slo...

want to turn PT row data into column data
original data: name win loss score paul 1 325 Jane 0 1 225 walt 1 400 nancy 0 200 jane 1 300 nancy 1 200 paul 1 365 walt 1 350 when i create p.t. I get (or a vague approximation) paul win 2 loss 0 avg 345 jane win 1 loss 1 avg 260 walt win 1 loss 1 avg 375 nancy win 0 loss 2 avg 200 but this is what I would like: name win loss avg Paul 2 0 345 Jane 1 1 260 walt 1 1 375 nancy 0 2 200 ---------------------------- HOw? tx phynkel, Grab the g...

Formula to calculate time
I was wondering if anybody knows of a formula to allow you to do calculations based on time. In other words, say I want to put a list of songs on a CD and their durations. Then, I want to add up the durations to get the full time of the CD, or my specific play list. So for example, using the information below: Ghostbusters - Ray Parker Jr. --- 5:23 (Just a guess) Phantom of the Opera Overture --- 3:55 (Another guess) Instead of 8:78, I'd want to see 9:18 Can this be done? Any help would be greatly appreciated. Thank you! -- Have a nice day! ~Paul Express Scripts, Charting the futu...

revisions to documents
Help. How can I place a revision date in a document, to change to the current date if and when changes are made to a specific page? You will need to be a bit more specific about what you are doing. However I suspect http://www.gmayor.com/save_numbered_versions.htm would be a better approach. If not, it is difficult to come up with an automatic solution that will not apply universally to date fields throughout the document - i.e. on pages that have not been changed. -- <>>< ><<> ><<> <>>< ><<> <>>< <>...

Forms - Call Data from Another Table
Hi I'm used to using lookups and forms etc but need to do something that I think links queries, VBA (completely new to) and forms: I have a form for creating new applicants I want to build a form that allows the user to search a contacts table on FirstName, MiddleName, Surname; receive a list of matches and then either 1. Select one of the matches which would then populate the applicants table or 2. Reject the matches and create a new record as normal Can you anyone point me in the right direction? Thanks James Sounds like you are asking how to do callbacks. Open a sub form ...

Update Worksheet data to other worksheets Data
Hi All I have two Excel file. One Excel (A) create by User and other Excel (B) is shared version posted on company shared directory. I need update Worksheet B base on Worksheet A. In Worksheet A, the key is Col A + Col B + Col Cm matched to Worksheet B, the key is Col A + Col D + Col E Below Column need to update WS A to WS B. The column may be changed. After each Updated. Work Sheet A -> WorkSheet B I - > P J ->Q K ->R .... Any suggestion to using VBA to Update Excel B ? If Records not f...

Strongly typed dataset for hierarchical data
Hi all, I'm trying to create a simple XML structure for storing tree-stryle data for a forum-like software, e.g. each post will have a body field, the ID of the user who posted the message, and zero or more subposts(replies). Thus it would allow for unlimited depth of subposts. I also need a simple table to store UserID, Full Name, etc of the users posting messages. I've created a schema in VS.NET 2003 as follows. However, now I need to add a relation between ID field of User table and UserID field of Post table (one-to-many). If I try to add such relation, I get "Failed ...

Copy data from different columns of multiple sheets
I have to summarize the latest sales number from different offices, more than 40 of them. The numbers are sitting in one Excel file with each office having one sheet. On each sheet the sales numbers for that office are listed monthly. The latest number for some offices are for Nov, some Oct, and some terminated offices with numbers as early as a couple of years ago. Here is what I have to do: I have to go to each sheet (named "office 1" to "office 50"), find the last column with data in that sheet and copy the column to a new sheet (say Sheet "Summary&q...

Importing external XML Data
I have data in the form of data tables stored in and being passed around in XML using WFC but being serailised as XML files. I would like to simply show this data via a Word template. Formatting the data into Word tables, this would very much a kin to using word as a reporting tool. I have looked at varoius examples but I can't find anything without droppping into code that can take an XML file , transform it into a word table. I prefer to find a way that user can modify the look and feel without having to resort to code. It would be great to use a custom control com...

Open procedures in a form using vba
How can i retrieve the procedures in a Form, make changes to the procedures and save all within a vba script. Particularly the onclick event procedure. ...

Will Access print data to a blank hard copy form?
I have blank printed forms that I want to print data from an Access report. The positioning of the report data on the blank form is important. Each record must print on a new page. Is this within the capabilities of Access, and if so how do I get instructions to set it up? Thanks in advance, -- Boomer642 Pride Runs Deep I'm not sure what you're asking. Since Access uses the Windows printer driver(s), when Access prints, Windows prints. Can you do what you need to from Word (get the print to happen in the right place)? If so, you can adjust where Access starts printing to line ...

Use that update
--rjwbztnq Content-Type: multipart/related; boundary="tscfwovfm"; type="multipart/alternative" --tscfwovfm Content-Type: multipart/alternative; boundary="fbsqpmek" --fbsqpmek Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Consumer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer. This update includes the functionality = of all ...

How to create and use the Handle philosophy in a Homemade class?
Hello, I have a non-derived homemade class with basic variables, I want to pass this class to a homemade ActiveX class. I think the best is to pass a handle pointer in the argument. But I don't know how to build a handle in my class? what is it anyway? I guess that is make easier the data transfer between complex ressources, I that is what I want to do. So how to handle the handle philosophy? thank you. let say my class is like that : class MyClass { int number; double amount; CFont myfont; OLE_COLOR mycolor; CStri...

Converting data....
Dear all, i need your special knowledges for converting a table. I have a table with special format having values for last year data, budget and actual of this year. (3 columns) and there are 2 columns of having as a percentage the difference bteween thos three columns. The values are in a local currency for each shop. i.e. USA has dollars. There is anyway that i can transform those values automatically to Euro. Either by coping the tables, or using currency converter, or doing a "tric"? Any good suggestions? Thanks in advance Manos Manos, Assuming your US$ value is in...

Import Data from Access
I want to create a membership booklet (5.5"x8.5"). This means folding an 8.5"x11" page in half. As you know that means the page with the A's will also be the page with the Z's So I need to import the data from Microsoft Access (or Excel) then printing it out so that the pages line up properly. Anyone know how to accomplish this? TIA BigWI What version Publisher? If you have 2003 use the catalog merge. -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "DES" <dstand_53146_no_Spam@yahoo.com&g...

Passing data to worker threads
I'm trying to make an application that use CAsynchSocket class (derived to my class CMySocket); i've put a button "Connect" on my formview (CMyView) and when it is clicked, i show to the user a modal dialog form (CWaitDlg): this dialog starts a new worker thread that make the connection in background. The problem is that the CMySocket object is a member of the CMyView so the code i use is: void CMyView::OnBnClickedBconnect() { m_waitDlg.m_sConnectSocket = &m_sConnectSocket; m_waitDlg.m_wParentView = this; m_waitDlg.m_strName = &m_strName; error = m...

Formating excel multiple paragraphs and colums using one source of data
Scenario: Sheet#1: column #1 product names separated by category names. column#2 prices corresponding to products. Final sheet is basically all product pricing. To print this out i need to create lay out on sheet # 2 This sheet would have three vertical frames. this frames would have two columns(one for product names one for pricis) Sheet #1 would project the content to sheet #2 in such way that if sheet #1 content changes all the content would get formated in number #2 sheet accordingly .(This content will have multiple pages within a sheet. How can I achieve that?. ...

Creating scientific data collection form
Is access right for me? I am a natural resource and environment management specialist and I would like to create a data collection sheet for an ecological survey. I have used access in the past for data management, however, I am still a beginner. I understand that I can use access to create forms that can be used to collect and enter data. But I am not sure how to do this as it has been a while since I have used access. Are there tutorials available for this? I wish to collect scientific data on a number of ecological characteristics. Are there examples of forms that have been...

Laptop Client Synchronisation
Hi, Hoping somebody can shed some light on this. When I click the Go Offline button on my laptop to synchronise the CRM data it's get's to the following: Synchronising 56 Letters to offline database and shows the following error: Failed move data for entity 'Letter' during action saDelete, countRows=56. Contact your system blah blah blah. I have deleted the campaign the letters were part of (this is a relatively new installation that I'm now starting to use) and all traces of the letters that I can see, but no joy. I even deactivated any entries with the 'Letter...

Linking Sharepoint data to Visio
Hello, I am looking into the Database possibilities of Visio Professional 2007. I managed to connect Sharepoint to Visio, but only in one way. So Sharepoint is leading and Visio follows. Is there a way to make the connection two ways, so that is Visio is changed, Shairepoint will follow ? Thanks, Arnold I'm going to assume that you have linked data to sharepoint via datarecordsets. Data recordsets can roundtrip information but it has to be done with custom code. Data recordsets can be read/updated in the document using xml. The export then has to be coded based upon the target yo...

Data from several worksheets
I've read some of the existing questions/answers ..... and I'd like to ask..... I'm using Excel 2002/XP. I currently have one file (Task List) with 6 worksheets (Areas of Responsibility) and four columns (Name, What, Start Date, Deadline). Each row is a different task. I would like to be able to retrieve my file and request that it gives me a new screen with all the tasks with a deadline of a specific date. Can this be done? If yes, how? I'm relatively new to Excel and do not know much about visual basic codes. Any help would be appreciated. Thanks. -- Diane Dia...

Extender
So I have about 10 fields, no spacing between them on the window. I need to add a few more fields in the middle of them. My worry is that the data in in the fields wont move along with the field. I figured I could use modifier to move the fields but that is not licensed either. Any suggestions to ensure nothing gets missed? I was thinking of updating the field data info on the extender table but was hoping a better way. Thanks all Stephen, You move the fields using Extender 'Move Field' option. Open the window you want to modify and then select the field you want to...

Data Query on the Fly
Does anybody have a Data Query on the fly example? I would like to query a Microsoft Access database and stuff the results into a new table. Can anybody help? I have used the External Data Function but would like to customize the SQL with data from the XLS sheet to return different results. Thank you in Advance, Mike Not exactly sure what you want to do, but perhaps http://www.erlandsendata.no/english/index.php?t=envbadac http://support.microsoft.com/default.aspx?scid=kb;en-us;257819 How To Use ADO with Excel Data from Visual Basic or VBA will be of some help. -- Regards, Tom ...

open database to input data
When a user opens the file for the database in Windows, how do we make it so the form for inputting data is already pulled up, so the user will not have to remember which form we want? One of the easier methods is to use the AutoExec macro. Create a macro; name it "autoexec"; then set its actions to open the form you want; and maybe minimize the database window, hide the toolbars, etc. When the mdb is opened, the autoexec macro is called and all its actions are run. A slightly more involved approach would be to create a Switchboard type form to serve as an on-scree...