+ Reply to Thread
Results 1 to 4 of 4

Lines disappear (Random ones) when converting to PDF

  1. #1
    Registered User
    Join Date
    07-22-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Lines disappear (Random ones) when converting to PDF

    Hi all,

    I hope I am placing this in the right section - I was a bit unsure.

    Something random keeps happening with a sheet.
    In excel I get rid of gridlines and draw in the ones I want visible, which has always worked fine. All lines are visible. I then convert the document to PDF and for some reason it does not show certain lines, random ones - in the PDF doc. Please can anyone help me? Even when I go back to the excel sheet the lines are still there and visible, and I even draw over them again and save and convert, but still random lines disappear in the PDF doc (the same random ones so far)

    I tried deleting all info inside the cells and re-saved and then converted to PDF and amazingly all lines were visible! But when I then went back in and re-typed everything, the same random lines disappeared when I converted it to PDF again.

    Please see the doc I have attached - excuse the redaction - it's a work document. The areas circled in red are where lines are missing.

    Please can anyone help?
    Any help would be greatly appreciated.

    SharedScreenshot.jpg

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Lines disappear (Random ones) when converting to PDF

    there is no doc attached. sorry. it sounds like either a cell border problem, or that your memory slots are messed up. something with excel of office perhaps? when you save a PDF file based on an excel format, nothing should disappear, I don't believe, simply because the program creates a replica of all the data and it's format that it is stored in and throws it into the PDF. that fact that a PDF file and an XL file were created by different manufacturers has nothing to do with that. or shouldn't.

  3. #3
    Registered User
    Join Date
    07-22-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Lines disappear (Random ones) when converting to PDF

    Hi vba_php

    Sorry you can't see the file - I have definitely attached it and can see it - I have attached it (or tried to, again)

    The random lines disappear whenever I save as anything but the original format - I even tried saving as an XLS and as soon as the save occurred - random lines disappeared.
    Attached Images Attached Images

  4. #4
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Lines disappear (Random ones) when converting to PDF

    no idea. if the doc is actually attached like you say, something's obviously wrong. you've got enough posts that links are allowed I think. upload it to one of the these and post the link after sharing it:

    https://drive.google.com/

    https://cloud.ibm.com/

    https://www.dropbox.com/

    https://app.box.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Checkbox disappear lines n chart?
    By Frigide in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-15-2019, 12:12 PM
  2. VBA buttons for hide/unhide rows disappear at random
    By derekopswat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2013, 01:10 PM
  3. Make these lines disappear!!
    By pickel182 in forum Excel General
    Replies: 4
    Last Post: 09-05-2008, 01:52 PM
  4. Grid lines disappear when importing data
    By nsv in forum Excel General
    Replies: 9
    Last Post: 09-17-2007, 06:46 PM
  5. Replies: 1
    Last Post: 06-12-2006, 05:35 PM
  6. Lines of a cell disappear HELP!
    By pgruening in forum Excel General
    Replies: 2
    Last Post: 09-07-2005, 06:19 PM
  7. [SOLVED] Pie chart data labels and lines disappear
    By Sally Sibthorpe in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-15-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1