Sorry if this is in the wrong place
i registered CALC XLS years ago and love the spreadsheet
quick and easy to use
however am encountering a formula problem that no one chas been able to help me with
I sent several emails to mariner software but none went through
i searched for Mariber software and discovered that it had gone feet up
I hope that someone can help me with the issue
it’s weird because it’s only happens in one spread sheet and copy pasting and savingbit under a new name does not work
BACKGROUND
I run a games club and use CALC XLS to monitor the scores
basically each game scores are recorded in a column opposite each players name
no problem there
there is a formula at the bottom of each column totaling all the scores which serve to be a check list so that the scores have been totaled correctly
again no problem there
in the first column I have each players total scor for the entire year upto date
this is where the problem lies
the formulas are all correct but every time I save the spreadsheet the formulas disappear and I have to reenter the formula, copy it, highlight the column need to paste the formula and paste it
works fine to THAT POINT
Exit the spread sheet and when I open it the next Time there is no proper formula in there
so each time I need to re copy and paste the formula into the column, save it, work with it, save it, exit it and when come back same issue again and again and again
I have as said
copied it
renamed it
to no avail
this is the ONLY spreadsheet giving this issue
I been doing this spread sheet since About 2015 and as said cites the only one with this issue
all the others are fine
unable to post the file
can see it but it’s greyed out
i registered CALC XLS years ago and love the spreadsheet
quick and easy to use
however am encountering a formula problem that no one chas been able to help me with
I sent several emails to mariner software but none went through
i searched for Mariber software and discovered that it had gone feet up
I hope that someone can help me with the issue
it’s weird because it’s only happens in one spread sheet and copy pasting and savingbit under a new name does not work
BACKGROUND
I run a games club and use CALC XLS to monitor the scores
basically each game scores are recorded in a column opposite each players name
no problem there
there is a formula at the bottom of each column totaling all the scores which serve to be a check list so that the scores have been totaled correctly
again no problem there
in the first column I have each players total scor for the entire year upto date
this is where the problem lies
the formulas are all correct but every time I save the spreadsheet the formulas disappear and I have to reenter the formula, copy it, highlight the column need to paste the formula and paste it
works fine to THAT POINT
Exit the spread sheet and when I open it the next Time there is no proper formula in there
so each time I need to re copy and paste the formula into the column, save it, work with it, save it, exit it and when come back same issue again and again and again
I have as said
copied it
renamed it
to no avail
this is the ONLY spreadsheet giving this issue
I been doing this spread sheet since About 2015 and as said cites the only one with this issue
all the others are fine
unable to post the file
can see it but it’s greyed out