ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   When Excel opens data is displayed and then blanks out. (https://www.excelbanter.com/excel-discussion-misc-queries/12345-when-excel-opens-data-displayed-then-blanks-out.html)

DonP

When Excel opens data is displayed and then blanks out.
 


I have Excel sp3 on win2k sp4

When trying to keep unwanted blank sections from printing I blanked out the
worksheet. I exited with out saving and reopened the spreadsheet. The data
is displayed for a few seconds and the sheet blanks out. I tried this from
another computer and got the same results.
A inport into MS ACCESS sees the data on the sheet.

Thanks for any help
(I am not a newbe I am a tobe)

Bernard Liengme

Please expand on what you did to "blank out" the sheet.
Did you hide it? If so: try Format|Sheet|Unhide
Did you cover some cells with fill?..... or what
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DonP" wrote in message
...


I have Excel sp3 on win2k sp4

When trying to keep unwanted blank sections from printing I blanked out
the
worksheet. I exited with out saving and reopened the spreadsheet. The
data
is displayed for a few seconds and the sheet blanks out. I tried this from
another computer and got the same results.
A inport into MS ACCESS sees the data on the sheet.

Thanks for any help
(I am not a newbe I am a tobe)




DonP

Thanks for the reply sorry this was delayed but I was having internet
slowness this morning

When I printed the sheet I got 9 pages 7 of them blank. I was trying to
delete the blank area. I selected sections and deleted them but they were not
removed. At some point I got into page view. When I went back to page 1 the
data was blank. I think I have checked for hidden and color settings.


"Bernard Liengme" wrote:

Please expand on what you did to "blank out" the sheet.
Did you hide it? If so: try Format|Sheet|Unhide
Did you cover some cells with fill?..... or what
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DonP" wrote in message
...


I have Excel sp3 on win2k sp4

When trying to keep unwanted blank sections from printing I blanked out
the
worksheet. I exited with out saving and reopened the spreadsheet. The
data
is displayed for a few seconds and the sheet blanks out. I tried this from
another computer and got the same results.
A inport into MS ACCESS sees the data on the sheet.

Thanks for any help
(I am not a newbe I am a tobe)






All times are GMT +1. The time now is 10:08 PM.

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