»
 

Go Back   ResellerRatings Store Ratings > ResellerRatings Forums > Tech Support

Reply
 
LinkBack Thread Tools Display Modes
Old 07-16-2003, 07:01 AM   #1 (permalink)
Registered User
 
Join Date: Jul 2002
Location: North Jersey or Southern RI take your pick
Posts: 114
jon112981 is on a distinguished road
Send a message via AIM to jon112981 Send a message via Yahoo to jon112981

Okay I'm having a totally weird problem in Exel. I have a formual in a cell that is based on calling other cells. I'll use the totaly simplified example of '=A3+1' and let's say this is in cell B3. Now normally when I select a vertical range and fill down it it changes the fomrula to '=A4+1' in cell B4. This is what I want it to do and it works perfectly. Just now, and twice yesterday, I used the fill down command and it properly fills down the formula in the formula bar but doesn't update the display to reflect that. If I highlight each cell, select the formula bar and hit enter it updates it with no further editing on my part but that is a pain. Is there some option in excel that accidently got turned on/off? Keep in mind all of the formula are right, the output on screen is just worng, and it's wrong when I print it.

jon112981 is offline   Reply With Quote
Old 07-16-2003, 07:57 AM   #2 (permalink)
Registered User
 
Join Date: Oct 2001
Location: Long Island, NY, USA
Posts: 20
MTAtech is on a distinguished road
Send a message via AIM to MTAtech Send a message via Yahoo to MTAtech
check that tools ->opttions->calculation is set to "automatic"
__________________
MTAtech - 'Fare and Balanced'
MTAtech is offline   Reply With Quote
Reply




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Most Active Discussions

Recent Discussions

All times are GMT -6. The time now is 04:43 AM.