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?

Tools Options Calculation Automatic.
Does that get you back to where you were before?

Regards,
Ryan---

--
RyGuy


"Troutman" wrote:

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?

Hi Ryan:

Thanks for the reply. I've got the new excel which I am less familiar with.
I can't even find "tools" in the new excel. When I open the program I see
tabs at the top for "Home" "Insert" "Page Layout" etc. Any thoughts?

"ryguy7272" wrote:

Tools Options Calculation Automatic.
Does that get you back to where you were before?

Regards,
Ryan---

--
RyGuy


"Troutman" wrote:

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?

Excel 2003 to 2007 translations are available via
http://www.microsoft.com/downloads/d...splaylang=enso Tools/ Options translates to Office button/ Excel options.--David Biddulph"Troutman" wrote in ... Hi Ryan: Thanks for the reply. I've got the new excel which I am less familiarwith. I can't even find "tools" in the new excel. When I open the program I see tabs at the top for "Home" "Insert" "Page Layout" etc. Any thoughts? "ryguy7272" wrote: Tools Options Calculation Automatic. Does that get you back to where you were before? Regards, Ryan--- -- RyGuy "Troutman" wrote: I'm a little bit frustrated. I have an excel workbook with a dozen orso 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. Sowhen 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 amountsimilar 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 theStar Gazette to $10,000 but the total remains $33,000. I've tried redoingthe 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 aday's worth of work in this workbook and when I brought it into the officeand plugged in the flash drive the workbook opened but I am unable toupdate it further (as described above). I store several workbooks on theflashdrive. On the weekend I opened several of those books just to referenceinformation 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 away to fix this simply? Or do I have to start all over again?

On Apr 15, 3:28*am, Troutman
wrote:
Hi Ryan:

Thanks for the reply. I've got the newexcelwhich I am less familiar with.
Ican'teven find "tools" in the newexcel. When Iopenthe program I see
tabs at the top for "Home" "Insert" "Page Layout" etc. *Any thoughts?



"ryguy7272" wrote:
Tools Options Calculation Automatic.
Does that get you back to where you were before?

Regards,
Ryan---

--
RyGuy

"Troutman" wrote:

I'm a little bit frustrated. I have anexcelworkbook 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'topenare 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?- Hide quoted text -

- Show quoted text -

Hi,

Perhaps your workbook is damaged. Why not try Advanced Excel Repair at
http://www.datanumen.com/aer/ ? It recovers several important Excel
xls files for me and is really helpful!

Alan