Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug T
 
Posts: n/a
Default calculations quit working

Well that little "=" trick helped ME out. I lose my calculations/links when
I move a sheet from one position to another within the workbook. I still
don't know why that happens or how to prevent it but at least I can repair it
now. Thanks!!

"Dave Peterson" wrote:

How do you know that it's not calculating?

If it's just the statusbar warning, maybe...

http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

ps. What does "cells don't formulate" mean?

One more way that might "kick start" excel.

Select all the worksheets (click on the leftmost tab and shiftclick on the
rightmost tab),

then edit|replace
what: = (equal sign)
with: =
replace all

Then rightclick on any worksheet and ungroup the sheets.



CJ wrote:

Our new network administrator tried to keep all company computers from going
on the internet, and in doing so he royally screwed up several spreadsheets
on my computer ... He eventually had to buy me a new computer, but one
spreadsheet still will not calculate ...

I've tried everything I know to get it to work ... All formula cells that
were calculating previous to his blooper still have data in them ... every
cell since then is not working ... and even with the new computer, the cells
don't formulate ...

HELP ...!!!


--

Dave Peterson

Reply
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
Calculation with Working day of the year Box666 Excel Discussion (Misc queries) 4 November 10th 05 06:33 PM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM
Working time and days Nortos Excel Worksheet Functions 5 May 6th 05 04:17 PM
Excel in Internet Explorer Menus quit working Phil Mullins Excel Discussion (Misc queries) 0 April 8th 05 10:15 PM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM


All times are GMT +1. The time now is 11:47 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"