Excel 2003 - Office

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two mission critical workbooks containg several workpages each. This
is payroll data.

The problems are that formulas will disappear, referred page points will
change, data in a cell will disappear. I'm spending more time correcting the
spreadsheets then I am getting them finished. Is there a hotfix for this?
 
You'll have to provide a little more info.
When does it "disappear/change"? While the book is active or after it's closed/re-opened.
Any macro's involved?
Is it a template?
 
The problem occurs primarily after a close=> open sequence. There are no
macros, but the design of the page is a template that I made and stored in
the templates folder. I made sure of that first.
--
Don




RWN said:
You'll have to provide a little more info.
When does it "disappear/change"? While the book is active or after it's closed/re-opened.
Any macro's involved?
Is it a template?
Click to expand...
 
So you built the template with formulas etc. and saved it as a template ".XLT"(?).
How are you opening it? (File-New or just File->Open)
Guess what I'm driving at is I'd need to now the exact sequence of events that lead to the
problems.

--
Regards;
Rob
------------------------------------------------------------------------
DonF said:
The problem occurs primarily after a close=> open sequence. There are no
macros, but the design of the page is a template that I made and stored in
the templates folder. I made sure of that first.
Click to expand...
 
Rob,

This is getting real serious for me. I have to make a visit to the Sate
Auditor's Office to answer questions about State Witholding problems and my
source date looks like scrambled eggs every time I open the two different
ledger's up.

I built a template that included formulas, headers, footers, column
headings. When I originally started the document, 6/18/07, I would open the
template and then using Edit> Copy Page I would place the template into my
open workbook.

From then on, when I Save then close the document, everything seems to be
fine.

However, when I open the document back up, a drill down formula that is
supposed to go look at and add cell "10D" and then return the total to the
same cell# on a master page goes squirrly on me. For example:

=SUM('Melanie Alexander'!D10,'Joseph Baker'!D10,'James D Bowden'!D10,'Marta
Bowden'!D10,'Lawrence Cain'!D10,'Charles Carter'!D10,'James
Farrell'!D10,'LizBeth Fuentes'!D10,'Kenneth Jackson'!D10,'Barry Wilcox'!D10)
--
Will look like this:

=SUM('Melanie Alexander'!D10,'Joseph Baker'!D9,'James D Bowden'!D9,'Marta
Bowden'!D9,'Lawrence Cain'!D10,'Charles Carter'!D10,'James
Farrell'!D9,'LizBeth Fuentes'!D9,'Kenneth Jackson'!D10,'Barry Wilcox'!D10)

I have to start each evening cleaning up the mess on every page. To say I'
loosing faith in Excel is being very kind. If it's a loose nut on the
keyboard (me) I'd appreciate knowing it. I've got to Monday morning at 10:00
AM to have this flattened!


Don
 
Rob,

No, I haven't tried using absolute cell identies, but I will. Why would the
cell numbers change on reopening the file be a cause cell numbers. What I
get is the cell reference actually changes? I have seen several instances
were the formula for the cell is correct but the cell itself is empty.
 
Don;
I can't replicate your problem-probably because I'm not sure what exactly you are doing
and, therefore, probably making some bad assumptions..

I'm assuming that;
- this is a payroll application and that you have worksheets for each employee "Melanie
Alexander, Joe Baker etc..
and that they are located in the same workbook.
- you have a Totals worksheet in this book and each cell is supposed to reflect the
totals of the cells in the individual sheets
- all sheets, including the Totals sheet, are identical and that you haven't hidden any
rows/columns.

If the foregoing is correct then to build the totals I would do as follows (using D10 as
an example);

In the Totals D10 cell
select the sum function
using the mouse, select the first Employee sheet
hold down the "Shift" key
using the mouse, select the last Employee sheet
release the "Shift" key and select cell D10 with the mouse
<Enter>
This should sum all the D10's for all the sheets

I've done this (not only here but in actual applications and haven't had any problems).

Again, I don't know if this is what you're doing so It's pretty difficult to suggest a
solution.
All I can say is that whenever I've had "strange" things occur in Excel (I started quite a
while ago with XL97) it's usually my "fault".

Feel free to correct my assumptions and provide more detail.
 
Rob,

I'll be able to test the way you do formulas tomorrow morning. I've been
mandated by my wife to take the night off. Appearently I want to go see the
newest Harry Potter movie and then go out for dinner. Actually I do want to
see it.

I'll be happy to let you know how it goes. I thank you for your all your
help and suggestions.

Your assumptions are almost spot on.
 
Back
Top