Hi, so I don't consider myself a total idiot with computers but I have worked in an office and know there are tons of people that know even less than me, but I apologize if my language isn't computer savy enough, lol

anyways, so i work for a small business now, I am using excel to hyperlink pdfs of invoices etc. the problem I am having is that it seems over some time I excel will not open then, (side note a notice pops up "cannot open" then has "was this information helpful" hahah I think it's hilarious)

I have noticed that in the "file path" the ones that cannot open have "roaming" in them, this is very annoying as I cannot open any of the files, is this an error on excels part, or is it mine, b/c I may or may not have moved some of the folders around at a later date, not sure if that should have an issue on the hyperlink, it just seems that over time they stop working.

Finaly last issue is that I simply cannot open an excel file without excel being open previously, so I have to open a blank sheet and from there click the open folder to open and files I want, you can image how annoying this is when I have excel attachments to open,

any help would be appreciated, if this have been mentioned in a previous thread im sorry and could you please direct me to that thread

Thanks,