Spreadsheet working differently between workstations

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

Guest

Hello

I have a worksheet where Columns A & B & C require manual input. Columns D, E, F and G have formuals and the cells are protected. All Columns are date format

Column G depends on the input in column b to calculate the formula. Most of the time Column B is the same as the input in Column A except for Fridays date at which time Column B is the Sunday date

If, I use the spreadsheet from my terminal I can copy the contents in Column A and input into column b either by using my mouse or by pressing shift and arrow to select , CTRL C to copy and CTRL V to paste. The integrity of my spreadsheet is perfect and all calculations in Column G are completed as expected

My co-worker, from her workstation does exactly the same thing using the same shared spreadsheet and when she copies the info from column a to column b, using either method above (she does prefer the CTRL C etc) the Column G formula displays #Name?. Once, the #Name? error message occurs, she cannot get rid of it even if she clears the contents of Column B and Clears the contents of column G and reinputs the formula

Question here is why does the spreadsheet behave differently between workstations. I cannot get the error message she does and she cannot get column G to calculate
 
Sherry

My best guess, based on your description and the fact you are dealing with
weekday calculations, is that one or more of the Functions(weekdays?) used is
from the Analysis Toolpak add-in at Tools>Add-ins.

You have it checked as loaded and co-worker does not.

Gord Dibben Excel MVP
 
Thank You Gord!

That would be exactly the cause. I installed the analysis pack add-in, in order to create the spreadsheet using the weekday function. It just never occurred to me to do the same for the other workstations. (D'OH). I would have been spinning my wheels for the next month if you hadn't helped me out!

Once again thank you!

----- Gord Dibben wrote: -----

Sherry

My best guess, based on your description and the fact you are dealing with
weekday calculations, is that one or more of the Functions(weekdays?) used is
from the Analysis Toolpak add-in at Tools>Add-ins.

You have it checked as loaded and co-worker does not.

Gord Dibben Excel MVP
 
Thanks for the feedback. Appreciated and useful for others who may have the
same problem.

Gord
 
Back
Top