Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save - some cells save but others don't
Hi
I entered data into a spreadsheet yesterday and saved it. Today some of that information is gone. It appears as if some cells were saved while other information entered into another column at the same time was not saved. this spreadsheet was created from a template I have used many times without any problems. It has macros but they don't relate to saving, it is not protected and its in Excel 2003. Any help would be most appreciated. AM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
save - some cells save but others don't
Are you sure you saved the workbook after you made all the changes?
Are you sure you opened the same workbook that you saved after all the changes were made? I would expect user error to be the cause (sorry). But if it happens enough so that you can duplicate the problem, maybe those macros do more than you know. If you can duplicate it on demand, I'd open excel in safe mode and test it. Close excel windows start button|run excel /safe click ok (macros will be disabled) File|Open your workbook and do some changes, then save the workbook. Close it and reopen it (still in safe mode). If the data looks good, then maybe it is a macro. If you can't duplicate this, I'm still betting on user error. AM wrote: Hi I entered data into a spreadsheet yesterday and saved it. Today some of that information is gone. It appears as if some cells were saved while other information entered into another column at the same time was not saved. this spreadsheet was created from a template I have used many times without any problems. It has macros but they don't relate to saving, it is not protected and its in Excel 2003. Any help would be most appreciated. AM -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
save - some cells save but others don't
Hi
thanks for the reply. I appreciate the role of user error but I don't think this is the case here as I typed information in two cells which were side by side and periodically saved. information in one cell was saved but sometimes not saved in the other. Unfortunately I haven't been able to repeat the problem. it might just have been a glitch but I wanted to check in case this was a known problem and I could avoid it in the future. "Dave Peterson" wrote: Are you sure you saved the workbook after you made all the changes? Are you sure you opened the same workbook that you saved after all the changes were made? I would expect user error to be the cause (sorry). But if it happens enough so that you can duplicate the problem, maybe those macros do more than you know. If you can duplicate it on demand, I'd open excel in safe mode and test it. Close excel windows start button|run excel /safe click ok (macros will be disabled) File|Open your workbook and do some changes, then save the workbook. Close it and reopen it (still in safe mode). If the data looks good, then maybe it is a macro. If you can't duplicate this, I'm still betting on user error. AM wrote: Hi I entered data into a spreadsheet yesterday and saved it. Today some of that information is gone. It appears as if some cells were saved while other information entered into another column at the same time was not saved. this spreadsheet was created from a template I have used many times without any problems. It has macros but they don't relate to saving, it is not protected and its in Excel 2003. Any help would be most appreciated. AM -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
save - some cells save but others don't
Hi
thanks for the reply. I appreciate the role of user error but I don't think this is the case here as I typed information in two cells which were side by side and periodically saved. information in one cell was saved but sometimes not saved in the other. Unfortunately I haven't been able to repeat the problem. it might just have been a glitch but I wanted to check in case this was a known problem and I could avoid it in the future. "Dave Peterson" wrote: Are you sure you saved the workbook after you made all the changes? Are you sure you opened the same workbook that you saved after all the changes were made? I would expect user error to be the cause (sorry). But if it happens enough so that you can duplicate the problem, maybe those macros do more than you know. If you can duplicate it on demand, I'd open excel in safe mode and test it. Close excel windows start button|run excel /safe click ok (macros will be disabled) File|Open your workbook and do some changes, then save the workbook. Close it and reopen it (still in safe mode). If the data looks good, then maybe it is a macro. If you can't duplicate this, I'm still betting on user error. AM wrote: Hi I entered data into a spreadsheet yesterday and saved it. Today some of that information is gone. It appears as if some cells were saved while other information entered into another column at the same time was not saved. this spreadsheet was created from a template I have used many times without any problems. It has macros but they don't relate to saving, it is not protected and its in Excel 2003. Any help would be most appreciated. AM -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
save - some cells save but others don't
The only time I've seen this kind of glitch is when I've screwed up.
AM wrote: Hi thanks for the reply. I appreciate the role of user error but I don't think this is the case here as I typed information in two cells which were side by side and periodically saved. information in one cell was saved but sometimes not saved in the other. Unfortunately I haven't been able to repeat the problem. it might just have been a glitch but I wanted to check in case this was a known problem and I could avoid it in the future. "Dave Peterson" wrote: Are you sure you saved the workbook after you made all the changes? Are you sure you opened the same workbook that you saved after all the changes were made? I would expect user error to be the cause (sorry). But if it happens enough so that you can duplicate the problem, maybe those macros do more than you know. If you can duplicate it on demand, I'd open excel in safe mode and test it. Close excel windows start button|run excel /safe click ok (macros will be disabled) File|Open your workbook and do some changes, then save the workbook. Close it and reopen it (still in safe mode). If the data looks good, then maybe it is a macro. If you can't duplicate this, I'm still betting on user error. AM wrote: Hi I entered data into a spreadsheet yesterday and saved it. Today some of that information is gone. It appears as if some cells were saved while other information entered into another column at the same time was not saved. this spreadsheet was created from a template I have used many times without any problems. It has macros but they don't relate to saving, it is not protected and its in Excel 2003. Any help would be most appreciated. AM -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |