ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shared Workbook (https://www.excelbanter.com/excel-discussion-misc-queries/219447-shared-workbook.html)

Darrel P

Shared Workbook
 
I have a sales workbook shared across 6 computers. Everything has worked
since installing 2007 months ago. I performed an advanced sort and now
numbers are posting in the wrong cells when saved. Have run diagnostics on
all machines. If I close excel and reopen the numbers repost to their proper
place. Any one have any Ideas on this?

Shane Devenshire[_2_]

Shared Workbook
 
If the sort range includes formulas are you recalculating? If not choose
Formulas, Calculation Options, Automatic.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Darrel P" wrote:

I have a sales workbook shared across 6 computers. Everything has worked
since installing 2007 months ago. I performed an advanced sort and now
numbers are posting in the wrong cells when saved. Have run diagnostics on
all machines. If I close excel and reopen the numbers repost to their proper
place. Any one have any Ideas on this?



All times are GMT +1. The time now is 12:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com