Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted info still prints out
Hi
Just wondering if anyone can tell me why my spreadsheet is acting crazy??!! When I delete all the info in several adjacent cells and hit save, the info still shows when I go to print preview. And it prints with all the deleted info!!??! There are cells that are linked to other workbooks, but if I close the file out and tell it not to update when I open it, the deleted info is still there!........Help! Is there a setting causing this?? -- smither fan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted info still prints out
Hi.
Maybe your workbook is corrupted. Try copying sheets to a new workbook. HTH Daniel Hi Just wondering if anyone can tell me why my spreadsheet is acting crazy??!! When I delete all the info in several adjacent cells and hit save, the info still shows when I go to print preview. And it prints with all the deleted info!!??! There are cells that are linked to other workbooks, but if I close the file out and tell it not to update when I open it, the deleted info is still there!........Help! Is there a setting causing this?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted info still prints out
I'd guess that you're not printing what you wanted/expected to print and that
you're not opening the file that you really wanted to open (the one that was just saved and closed). Ross wrote: Hi Just wondering if anyone can tell me why my spreadsheet is acting crazy??!! When I delete all the info in several adjacent cells and hit save, the info still shows when I go to print preview. And it prints with all the deleted info!!??! There are cells that are linked to other workbooks, but if I close the file out and tell it not to update when I open it, the deleted info is still there!........Help! Is there a setting causing this?? -- smither fan -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted info still prints out
FYI-I think the answer has been found. It's under Tools-Options-Calculation.
Unchecking "Save external link values" seems to have fixed the problem. Thanks to both Daniel C. and Dave Peterson for taking a shot at it and replying so quickly. I was having trouble getting on the net last week, or I would have replied to you both sooner. -- smither fan "Ross" wrote: Hi Just wondering if anyone can tell me why my spreadsheet is acting crazy??!! When I delete all the info in several adjacent cells and hit save, the info still shows when I go to print preview. And it prints with all the deleted info!!??! There are cells that are linked to other workbooks, but if I close the file out and tell it not to update when I open it, the deleted info is still there!........Help! Is there a setting causing this?? -- smither fan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected Worksheets with info that needs to be deleted. | Excel Discussion (Misc queries) | |||
In an excel document the info n row 2 prints out on both pages? He | Excel Discussion (Misc queries) | |||
If No is deleted in middle of sequence,Nos alter after deleted No | New Users to Excel | |||
How do write a formula so that only rows with info prints? | Excel Worksheet Functions | |||
½ symbol prints a 2 and Winding square box prints a F | Excel Discussion (Misc queries) |