LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Worksheet formulas stopped working

I'm a little bit frustrated. I have an excel workbook with a dozen or so tabs
at the bottom. All of the formulas within each tab stopped working. These are
very basic formulas. We are publishers of several weekly newspapers and
magazines. I keep month by month tabs at the bottom of the workbook. So when
I click on the January Tab for instance, all of the publications that
published in January appear by name with the revenue they produced. Each
revenue total is added up and then compared against a budgeted amount similar
to this:

Story County Weekly $18,000
Boone County Weekly $10,000
Star Gazette $ 5,000

Total Revenue: $33,000
Budgeted: $27,000
Variance: $ 6,000

I can alter the numbers in the cells for instance I could change the Star
Gazette to $10,000 but the total remains $33,000. I've tried redoing the
formula using conventional means but the totals still don't change.

The only common thread here is that I store this info on a falsh drive. I
work on a PC in my office and a laptop at home. This weekend I did a day's
worth of work in this workbook and when I brought it into the office and
plugged in the flash drive the workbook opened but I am unable to update it
further (as described above). I store several workbooks on the flashdrive. On
the weekend I opened several of those books just to reference information I
needed for the workbook in question...all of those workbooks are also
disabled. However the other books that resided on the flashdrive that I
didn't open are still functional.

I'm up against it here because I have a deadline to make. Is there a way to
fix this simply? Or do I have to start all over again?


 
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
My formulas stopped working even though equations are correct bkristal Excel Discussion (Misc queries) 2 June 19th 07 01:32 AM
Formulas Stopped Working djcircman Excel Discussion (Misc queries) 2 April 25th 07 04:19 PM
Linked Formulas have stopped working! Jules Excel Worksheet Functions 0 November 30th 06 05:08 PM
formulas have stopped working automatically meris Excel Discussion (Misc queries) 1 November 2nd 06 11:26 PM
why formulas have stopped working in Excel? queenjude Excel Worksheet Functions 3 August 16th 05 08:37 PM


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