LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
John Lovin
 
Posts: n/a
Default

Gord,

I figured it out...thanks...Geeze...I've not EVER had this much trouble!
Thanks for the help.

John

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
John

The [group] means you have more than one worksheet selected.

This will not affect calculation setting, but can cause disastrous effects

on
the sheets in the group.

What you are entering/formatting on one sheet will be done to all sheets

in
the group.

You will notice two or more sheet tabs are colored white. These are the
sheets that are grouped.

Select an ungrouped sheet or right-click on any sheet and "ungroup

sheets".

Depending upon how long you have had the sheets grouped, you could have
some(many?) errors on these sheets.

Check carefully before ungrouping.


Gord Dibben Excel MVP

On Tue, 18 Jan 2005 12:46:37 -0500, "John Lovin"
wrote:

Ok. I thought I'd figured it out. When I open the file, in the Title

Bar,
it has the file name followed by the word [Group] and the formulas are

still
screwed up.

Help!

John

"John Lovin" wrote in message
...
Ok. This is strange. I just figured out what the problem is with the
recalculation, but don't know what caused it. In the
<Tools<Options<Calculation Menu, Calculation was set to Manual. Do

any
of you know how this could happen? Some sort of inadvertant hot key

combo?
Virus?

Thanks,

John

"John Lovin" wrote in message
...
I've never had this before. I track information on a weekly basis

and
the
worksheet uses formulas (obviously). I've been just opening the
spreadsheet
and entering new data and the formulas recalculate. This week, when

I
put
the new data in, the totals in the cells with the formulas didn't

update.
The formula is correct =C6+D6 or whatever), but no recalculation.

Any suggestions?

Thanks in advance.

John Lovin








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make Excel run limited number of formulas on a given worksh John Excel Discussion (Misc queries) 0 January 12th 05 04:29 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 04:23 PM
Why won't formulas obey vertical alignment commands? imoux1 Excel Discussion (Misc queries) 2 December 28th 04 04:45 PM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 01:15 AM
Formula's not working Dave Excel Discussion (Misc queries) 2 December 7th 04 08:01 PM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"