Question

Locked

Excel: Shared a workbook and now spreadsheet will not calculate

By cmikesh ·
I have a sorce spreadsheet for which another sheet is linked to pull data. I shared the workbook which may or may not be part of the problem. When I make formula changes in the workbook, the formulas are copying and show in the cell, but the calculation does not seem to be working. It will show zero most of the time.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

More than likely,

by ThumbsUp2 In reply to Excel: Shared a workbook ...

it's a formula problem, not a calculation problem. If you're getting zeros in CHANGED cells, your formulas are doing exactly what you told them to do AND they can find the source data AND they're calculating. If they weren't, you would get an error.

If these formulas used the conditional sum wizard that sets the { } curley brackets around the formula, you need to hold CTRL+SHIFT while pressing ENTER in that cell after you have changed it.

Collapse -

Iteration box

by evan.frantzeskos In reply to Excel: Shared a workbook ...

If you use circular references in your spreadsheet, make sure the iteration check box is checked (Tools->Options->Calculation). Sometimes when you share a workbook, the checkmark disappears.

Collapse -

Tools / Addins / Analysis Toolpak

by gasummer In reply to Iteration box

When sharing a spreadsheet that required BIN2DEC & DEC2BIN functions, other users couldn't get the values to calculate because they did not have the Analysis Toolpak addins.
When they sent the spreadsheet back to me, the vaules would not calculate without copying the formulas anew.

Back to Software Forum
4 total posts (Page 1 of 1)  

Software Forums