Welcome to Lockergnome.com!
HomeHome FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Copied formulas

  
   Home -> Office -> General Protection Fault Errors RSS
Next:  General Protection Fault Errors: Trouble opening more than one .xls at a time  
Author Message
Nanninore

External


Since: Jul 14, 2004
Posts: 3



(Msg. 1) Posted: Wed Jul 14, 2004 1:17 pm
Post subject: Copied formulas
Archived from groups: microsoft>public>excel>crashesgpfs (more info?)
I recently grouped worksheets within the same workbook together to facilitate printing. The worksheets were ungrouped after printing. We're having trouble copying formulas from one cell to another. The formulas copy correctly, however, the data that displays is from the original cell, not the cells referenced in the formula. Additionally, when data changes in the cells the formula points to, no changes are recognized. Any ideas?
Back to top
Login to vote
Rob Bovey

External


Since: Aug 25, 2003
Posts: 242



(Msg. 2) Posted: Wed Jul 14, 2004 3:23 pm
Post subject: Re: Copied formulas [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Nanninore" <Nanninore RemoveThis @discussions.microsoft.com> wrote in message
news:680B0D0C-E332-4435-94E1-45DAC26AE487@microsoft.com...
 > I recently grouped worksheets within the same workbook together to
facilitate printing. The worksheets were ungrouped after printing. We're
having trouble copying formulas from one cell to another. The formulas copy
correctly, however, the data that displays is from the original cell, not
the cells referenced in the formula. Additionally, when data changes in the
cells the formula points to, no changes are recognized. Any ideas?

Are you sure that you don't have calculation set to manual? Choose
Tools/Options/Calculation from the Excel menu and make sure the Automatic
option is selected.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
<a style='text-decoration: underline;' href="http://www.appspro.com/" target="_blank">http://www.appspro.com/</a>

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *<!-- ~MESSAGE_AFTER~ -->
Back to top
Login to vote
Nanninore

External


Since: Jul 14, 2004
Posts: 3



(Msg. 3) Posted: Thu Jul 15, 2004 6:56 am
Post subject: Re: Copied formulas [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks, you were right - somehow the formula calculations were set to manual. Perhaps it automatically happens when you group pages. I'm in good shape now. Thanks, Nanninore

"Rob Bovey" wrote:

 > "Nanninore" <Nanninore.TakeThisOut@discussions.microsoft.com> wrote in message
 > news:680B0D0C-E332-4435-94E1-45DAC26AE487@microsoft.com...
  > > I recently grouped worksheets within the same workbook together to
 > facilitate printing. The worksheets were ungrouped after printing. We're
 > having trouble copying formulas from one cell to another. The formulas copy
 > correctly, however, the data that displays is from the original cell, not
 > the cells referenced in the formula. Additionally, when data changes in the
 > cells the formula points to, no changes are recognized. Any ideas?
 >
 > Are you sure that you don't have calculation set to manual? Choose
 > Tools/Options/Calculation from the Excel menu and make sure the Automatic
 > option is selected.
 >
 > --
 > Rob Bovey, MCSE, MCSD, Excel MVP
 > Application Professionals
<font color=purple> > <a style='text-decoration: underline;' href="http://www.appspro.com/</font" target="_blank">http://www.appspro.com/</font</a>>
 >
 > * Please post all replies to this newsgroup *
 > * I delete all unsolicited e-mail responses *
 >
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->
Back to top
Login to vote
Rick D'Amico

External


Since: Jul 15, 2004
Posts: 1



(Msg. 4) Posted: Thu Jul 15, 2004 6:09 pm
Post subject: Re: Copied formulas [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I have encountered very similar problem where I update
data in one tab and another tab that references those
updated cells does not get updated. Calculation is set to
automatic. If I go into cell to edit formula it will then
get updated. I have encountered this in two different
files were created with a previous version of Excel in the
last week since we upgraded to Excel 2003.
 >-----Original Message-----
 >"Nanninore" <Nanninore RemoveThis @discussions.microsoft.com> wrote
in message
 >news:680B0D0C-E332-4435-94E1-45DAC26AE487@microsoft.com...
  >> I recently grouped worksheets within the same workbook
together to
 >facilitate printing. The worksheets were ungrouped after
printing. We're
 >having trouble copying formulas from one cell to
another. The formulas copy
 >correctly, however, the data that displays is from the
original cell, not
 >the cells referenced in the formula. Additionally, when
data changes in the
 >cells the formula points to, no changes are recognized.
Any ideas?
 >
 > Are you sure that you don't have calculation set to
manual? Choose
 >Tools/Options/Calculation from the Excel menu and make
sure the Automatic
 >option is selected.
 >
 >--
 >Rob Bovey, MCSE, MCSD, Excel MVP
 >Application Professionals
 >http://www.appspro.com/
 >
 >* Please post all replies to this newsgroup *
 >* I delete all unsolicited e-mail responses *
 >
 >
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->
Back to top
Login to vote
Nanninore

External


Since: Jul 14, 2004
Posts: 3



(Msg. 5) Posted: Fri Jul 16, 2004 6:49 am
Post subject: Re: Copied formulas [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
We have recently upgarded too. I'll continue to validate the data generated to be sure they are updating. Once I set the formula calculations to automatic, they seemed to work fine. Thanks, Nanninore

"Rick D'Amico" wrote:

 > I have encountered very similar problem where I update
 > data in one tab and another tab that references those
 > updated cells does not get updated. Calculation is set to
 > automatic. If I go into cell to edit formula it will then
 > get updated. I have encountered this in two different
 > files were created with a previous version of Excel in the
 > last week since we upgraded to Excel 2003.
  > >-----Original Message-----
  > >"Nanninore" <Nanninore.TakeThisOut@discussions.microsoft.com> wrote
 > in message
  > >news:680B0D0C-E332-4435-94E1-45DAC26AE487@microsoft.com...
   > >> I recently grouped worksheets within the same workbook
 > together to
  > >facilitate printing. The worksheets were ungrouped after
 > printing. We're
  > >having trouble copying formulas from one cell to
 > another. The formulas copy
  > >correctly, however, the data that displays is from the
 > original cell, not
  > >the cells referenced in the formula. Additionally, when
 > data changes in the
  > >cells the formula points to, no changes are recognized.
 > Any ideas?
  > >
  > > Are you sure that you don't have calculation set to
 > manual? Choose
  > >Tools/Options/Calculation from the Excel menu and make
 > sure the Automatic
  > >option is selected.
  > >
  > >--
  > >Rob Bovey, MCSE, MCSD, Excel MVP
  > >Application Professionals
  > >http://www.appspro.com/
  > >
  > >* Please post all replies to this newsgroup *
  > >* I delete all unsolicited e-mail responses *
  > >
  > >
  > >
  > >.
  > >
 ><!-- ~MESSAGE_AFTER~ -->
Back to top
Login to vote
Mag

External


Since: Dec 08, 2006
Posts: 2



(Msg. 6) Posted: Tue Aug 07, 2007 8:10 am
Post subject: Re: Copied formulas [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I and some of my coworkers run into the same problem, except that our
Calculation options are already set to Automatic. This doesn't happen
consistently; some times it works fine, other times it doesn't. It happens
on old spreedsheets created in Excel 2000 as well as brand new ones. We all
use Excel 2003 now. Any other ideas?
Mag


"Rob Bovey" wrote:

> "Nanninore" <Nanninore.RemoveThis@discussions.microsoft.com> wrote in message
> news:680B0D0C-E332-4435-94E1-45DAC26AE487@microsoft.com...
> > I recently grouped worksheets within the same workbook together to
> facilitate printing. The worksheets were ungrouped after printing. We're
> having trouble copying formulas from one cell to another. The formulas copy
> correctly, however, the data that displays is from the original cell, not
> the cells referenced in the formula. Additionally, when data changes in the
> cells the formula points to, no changes are recognized. Any ideas?
>
> Are you sure that you don't have calculation set to manual? Choose
> Tools/Options/Calculation from the Excel menu and make sure the Automatic
> option is selected.
>
> --
> Rob Bovey, MCSE, MCSD, Excel MVP
> Application Professionals
> http://www.appspro.com/
>
> * Please post all replies to this newsgroup *
> * I delete all unsolicited e-mail responses *
>
>
>
>
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Protection Fault Errors All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Categories:
 General
 Microsoft Windows XP
 Microsoft Windows Vista
 Microsoft Windows (other)
  Microsoft Office
 Microsoft Office (other)
 Computer Security
 Linux
 Movies

[ Contact us | Terms of Service/Privacy Policy ]