Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
The dissapearing Data (on refresh) mystery
I build large financial models working with collegues in India. We have hit a
problem with Pivit charts that refer to data on the financial models that we send to each other. They work perfectly well when we view them on the computer on which the Pivot was created but mysteriously lose the data on refresh when we send it to each other and open the file on a different computer. Interestingly the pivot fuctions perfectly providing you do not refresh the data. We have even created the same pivot table twice on the same worksheet, once on my PC and once on my collegues machine - when I recieved it back my pivot chart still worked but my collegues pivot lost the data on refresh. My collegue had the same problem only the other way round. We have run out of ideas - so any help would be gratefully recieved. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Manual entered data on excel ms query is misaligned after refresh | Excel Discussion (Misc queries) |