Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Odd problem - loosing cell information
Just opened a financial workbook that has several several columns. The data
in one column is missing for the past five days. This column is updated daily and the data was current as of yesterday but now it is missing. I would understand, if only the last days information was missing (could have forgot to save), but not the last five days. Has anyone else seen this problem or have an idea what happened? Thanks Ted |
#2
|
|||
|
|||
Just a guess.
You have multiple workbooks of the same name--but in different folders. And you're opening the wrong one every once in awhile. Ted wrote: Just opened a financial workbook that has several several columns. The data in one column is missing for the past five days. This column is updated daily and the data was current as of yesterday but now it is missing. I would understand, if only the last days information was missing (could have forgot to save), but not the last five days. Has anyone else seen this problem or have an idea what happened? Thanks Ted -- Dave Peterson |
#3
|
|||
|
|||
No. Only one file in one folder. I wish it was that easy.
Thanks for the quick response. Ted "Dave Peterson" wrote in message ... Just a guess. You have multiple workbooks of the same name--but in different folders. And you're opening the wrong one every once in awhile. Ted wrote: Just opened a financial workbook that has several several columns. The data in one column is missing for the past five days. This column is updated daily and the data was current as of yesterday but now it is missing. I would understand, if only the last days information was missing (could have forgot to save), but not the last five days. Has anyone else seen this problem or have an idea what happened? Thanks Ted -- Dave Peterson |
#4
|
|||
|
|||
A silly guess...
Your file was on a network drive and your IT folks restore the drive the way it was earlier in the week. Everytime I've seen this kind of error, it's always been the user's (pronounced my) fault. Ted wrote: No. Only one file in one folder. I wish it was that easy. Thanks for the quick response. Ted "Dave Peterson" wrote in message ... Just a guess. You have multiple workbooks of the same name--but in different folders. And you're opening the wrong one every once in awhile. Ted wrote: Just opened a financial workbook that has several several columns. The data in one column is missing for the past five days. This column is updated daily and the data was current as of yesterday but now it is missing. I would understand, if only the last days information was missing (could have forgot to save), but not the last five days. Has anyone else seen this problem or have an idea what happened? Thanks Ted -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
No. A restore hasn't occurred. Besides the other columns in the workbook
are up to date. Thanks, Ted "Dave Peterson" wrote in message ... A silly guess... Your file was on a network drive and your IT folks restore the drive the way it was earlier in the week. Everytime I've seen this kind of error, it's always been the user's (pronounced my) fault. Ted wrote: No. Only one file in one folder. I wish it was that easy. Thanks for the quick response. Ted "Dave Peterson" wrote in message ... Just a guess. You have multiple workbooks of the same name--but in different folders. And you're opening the wrong one every once in awhile. Ted wrote: Just opened a financial workbook that has several several columns. The data in one column is missing for the past five days. This column is updated daily and the data was current as of yesterday but now it is missing. I would understand, if only the last days information was missing (could have forgot to save), but not the last five days. Has anyone else seen this problem or have an idea what happened? Thanks Ted -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Any "helpful" macros that may be clearing the ranges?
I really got nothing! Ted wrote: No. A restore hasn't occurred. Besides the other columns in the workbook are up to date. Thanks, Ted "Dave Peterson" wrote in message ... A silly guess... Your file was on a network drive and your IT folks restore the drive the way it was earlier in the week. Everytime I've seen this kind of error, it's always been the user's (pronounced my) fault. Ted wrote: No. Only one file in one folder. I wish it was that easy. Thanks for the quick response. Ted "Dave Peterson" wrote in message ... Just a guess. You have multiple workbooks of the same name--but in different folders. And you're opening the wrong one every once in awhile. Ted wrote: Just opened a financial workbook that has several several columns. The data in one column is missing for the past five days. This column is updated daily and the data was current as of yesterday but now it is missing. I would understand, if only the last days information was missing (could have forgot to save), but not the last five days. Has anyone else seen this problem or have an idea what happened? Thanks Ted -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
message "Too many different cell formats" problem | Excel Worksheet Functions | |||
transfering information from one cell to another | Excel Worksheet Functions | |||
store some of the information from one cell into another | Excel Discussion (Misc queries) | |||
Import - blank cell problem. | Excel Worksheet Functions | |||
Problem with IF condition or vector lookup? | Excel Worksheet Functions |