Re: Two Input Data Tables in Excel

Hi Tango

works fine for me in Excel 2003 - are you sure calculation is set to
automatic, tools / options / calculation ?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"tango" <tango@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2DF2795E-ECEF-4379-B32E-776F938FECEC@xxxxxxxxxxxxxxxx
>I have tried to set up a two input data table just as it was described, but
> the numbers in the table always come out the same as the cornerstone cell.
> I
> noticed the table works correctly in older versions of Excel but does not
> in
> Excel 2003. I do not see how the process has changed but either it has or
> I
> am doing it wrong. What is the deal?
>
>


.

Relevant Pages

  • Re: Getting around Dependency Tree Performance Problems
    ... That does not work there is no proper dependency on the Range... ... The Excel Calculation Site ... cell range on my system from 65 seconds to 2 seconds. ...
    (microsoft.public.excel.programming)
  • RE: Cannot get code to work for API Save Dialog Box
    ... Then you could include it in your query and export it to Excel ... to use the default value property of the new text box to do the calculation. ... I checked the cells in the spreadsheet created and the cells are blank. ... cells where you expect the formula to calculate the totals. ...
    (microsoft.public.access.forms)
  • Re: Form Protection with Excel Object Embedded
    ... the best field to base the calculation on might be the one in the example titled 'Calculate the # Days Difference ... The date input format is of no consequence, provided both dates have a day, month and year- you might want to enforce this via the ... Excel workbook, though. ... At most, you'll need to insert a paragraph break immediately before the workbook, then format the workbook ...
    (microsoft.public.word.application.errors)
  • Re: Disabling Autocalculation when opening CSV files
    ... For Each osht In ActiveWorkbook ... I am not very technical in Excel myself but I would like to add that: ... The calculation mode is always set to Manual (without recalculation ... Switch to Manual calculation and turn off Recalculate before save. ...
    (microsoft.public.excel.programming)
  • Re: WORD doc info into FMP?
    ... Bill, your solution has nothing to do with search and replace, or Excel but neither did option number 4 in my list, which was to import into a single record and then use position to populate other fields, as you suggested. ... I certainly acknowledged that you made his life easier by actually providing the necessary base calculation, but it was still the same method, and the method absolutely requires that all headings in all records have identical spelling. ... None of my suggestions required scripts, and I don't think the original poster actually meant scripts, but rather calculations, though that is simply a guess on my part. ...
    (comp.databases.filemaker)