ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Odd problem - loosing cell information (https://www.excelbanter.com/excel-discussion-misc-queries/18315-odd-problem-loosing-cell-information.html)

Ted

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




Dave Peterson

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

Ted

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

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

Ted

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

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


All times are GMT +1. The time now is 11:05 PM.

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