| View previous topic :: View next topic |
| Author |
Message |
suz
Power User
Joined: 21 May 2004
Posts: 66
|
 Posted: Tue Feb 02, 2010 1:09 pm Post subject: cell references |
 |
|
Trying to reference cells from one workbook to another. When the formulas are inserted into the second workbook (using click and drag so as to head off typos in the formulas) it seems to work fine.
Two things trigger problems. One.. if I try to change the cell addresses to absolute cell references they recalculate and give a wrong total.
Second.. I noticed if I left the addresses alone and as long as it was working okay, once I get out and back into the spreadsheet, the totals also go out of whack. All the formulas would appear to have the same total.. they shouldn't.
Could there be a bug with referencing cells between workbooks? What started this was worksheets I had not trouble with in the past now don't calculate correctly. I don't think anything about the formulas has changed so want to blame it on an upgrade.. using version 3.1.1 and Linux.
here is an example of the formula
=SUM('file://path'#$SHEET1.B3:E3)
won't let me change to
=SUM('file://path'#$SHEET1.$B$3:$E$3)
_________________
suz |
|
| Back to top |
|
 |
BigAndy
OOo Enthusiast
Joined: 03 Jan 2010
Posts: 150
|
| Posted: Tue Feb 02, 2010 1:22 pm Post subject: |
|
|
Are you work in Database or in Calc???
What kind of workbook you want find in base?  |
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Tue Feb 02, 2010 1:32 pm Post subject: |
|
|
| Moved from the Base to the Calc section. |
|
| Back to top |
|
|
suz
Power User
Joined: 21 May 2004
Posts: 66
|
| Posted: Tue Feb 02, 2010 1:41 pm Post subject: |
|
|
you are correct.. this is a Calc question...
thanks!
_________________
suz |
|
| Back to top |
|
|
|
