I have a spreadsheet I'm creating in Excel to track jobs through the shop. In it I have some formulas to math for me. Problem is, it's really easy to accidentally delete or erase the formula and screw up the cell, so is there a way (without locking or requiring a password) to protect the formula inside that cell so it doesn't lose it's format and can still be typed in to? I know how to lock it, but then you can't add any new information, and the only other trick I know requires a password every time you want to add new information. Also, without the use of a 3rd party plug-in, is there a way to make a cell have a date finder calendar?

On the latest build of Illustrator, I am trying to create a new document and I set the bleed to 0 all around, and when it creates the new page, it's adding 1/8" of bleed to the top. You can't set the document defaults like you can in InDesign, so how do I fix? It's not a deal-breaker, but it really is an annoyance.

Having been out of the game a few years, I ran into a couple issues today and discovered two new (to me anyway) cool tricks.

If you need an image from an Acrobat file (without any of the text or crap someone might have included in the file), open the file in Photoshop. When you get the preview window, tic the radio button that says, "images," (it defaults to whatever you did last). Voila - an unmolested image.

#2, in InDesign, which was freshly installed on my machine, the default setting for image handling was set to Auto-Fit "on." This meant every time I tried to edit the frame on a placed image, the image would resize and/or distort. To turn the default Auto-Fit, "off," it's not in the preferences - you have to go to Object --> Fitting --> Frame Fitting Options and turn it off there.

Anyone know where I can get Xerox production scanner parts other than from Xerox directly? We have several W130 production scanners, and we need to AF rollers for it. It's $108 from Xerox, but I can't find anyone else who might sell this part. Not available from Amazon, OfficeDepot or Staples. 

Looking for something like Printsmith but cheaper. Any suggestions?

Second day on the job and run into my first major issue. Using Prisma to feed a canon 10,000 VP and it lost its ability to offset stacks. Yes, we turned it off and turned it on again.

There's a cross promotion going on right now between Wyze and Google Nest Home. (There's also this). You can get a 7" Google Home smartscreen and an indoor/outdoor video surveilance camera for $79.99 (50% off). Google Home integrates with ADT and if you have Wyze it does that (and Arlo). I dropped Xfinity ($165/mo for 2gb cable internet, home phone and alarm/monitoring) to get Fidium ($69.99/mo for home phone and 2gb fibre-optic internet but no alarm) and I have 5 Arlo cams and 4 Wyze cams and Google Home monitors it all. I have Arlo cloud recording and Wyze SD recording and I programmed Home, Away and Night time modes with push alerts. If I'm Away from Home and something trips a camera, I get video immediately (and recorded) and I can 1-touch activate an alarm/call for help. 

I also have a Ring doorbell and motion floodlight, but Google Home doesn't integrate with Ring.

I am using CS 5.1 at home; it's all I got anymore that works. I can't remember how to set file preferences so that it goes to the most recently browsed folder. I have 74 signature tif scans I need to place on to vector art for a T-shirt, and it sucks.

I have 8gb RAM... just for fucking around with at home. Should I spend a few bucks and upgrade it to 16gb RAM?

I have an issue at home on one of my Windows 10 machines. This one happens to be an AMD Phenom 8450 Triple-Core 2.10Ghz with 8gb RAM 64-bit. It appears, so far, that it ONLY hangs on internet and NOT on games or other apps. I have Google Chrome AND MS Edge, and it appears to hang more on Chrome and less on Edge, but does hang on both. By *hang,* I mean it just totally locks up and stops functioning for several minutes, usually resulting in a 2nd window stating, "Page Unresponsive." I've pretty much attempted every internet fix short of doing a Win10 reset. It happened just now typing this message for 3-4 minutes

During the *hang,* for lack of a better term, I can still access other Windows 10 functions... if Chrome hangs, I can still browse on Edge, and vice-versa. I can still play music, or games, or access features like the calculator, etc. It's super annoying, and I'd like to fix it without resorting to the reset. I've run Malwarebyters, Windows Defender, Stinger, etc. and come up blank. I did do an Event Viewer and found a recurring problematic event, schannel error 36871, but it also does hang in the Event Viewer. I have taken every step imaginable to eliminate this issue, including Registry level adjustments, and for 48 hours there have been no schannel errors, but it still hangs.

It *may* be an MS Windows security 5379 error, but event viewer doesn't show this as a catastrophic error. Any ideas?

I know that everything Adobe CS5.5 and prior, the activation servers are no longer running. I reset my home workstation and lost my CS at home. I am reinstalling CS4, but it won't accept my CS3 serial number. Any ideas on how to get it installed?

Holy schniekes... just got my first job supplied entirely as .odg files

https://www.google.com/search?q=what+is+an+odg+file&rlz=1C5CHFA_enUS730US730&oq=what+is+an+odg+file&aqs=chrome..69i57j0l5.3649j1j8&sourceid=chrome&ie=UTF-8

It's some kind of google vector art. Has anybody worked with these before, and can tell me what kind of pitfalls am I falling in to?

I've had my current phone for 3 or 4 years now. I forget. It's a Samsung Galaxy S7 Edge, and it was alright. I had an iPhone 3 over a decade ago, and then 3 Samsungs in a row, but this one is on it's last legs and I'm thinking I'm ready to buy a new one. What would you go with and why? I'm leaning towards the iPhone 11 Pro 256gb but would consider another Galaxy Edge or perhaps the Pixel. I like a lot of things about the Android line, but I think I'm ready to just enjoy a phone that just always works instead of the tireless tinkering I seem to always be doing with my Androids.

I had a hiccup over here and my ColorPress driver got deleted. Obviously, I still have it, but now it goes direct to print instead of going to the hold queue. I can't remember how I set it up originally... help!!

I've had a steady stream of work today, but I can't imagine that will continue for long. Has anyone updated to Catalina yet? We don't have RIP or Impo software to deal with; just Suitcase and CC2020. I'm fairly certain those will play nice, but does Catalina screw anything else up? It won't mess up fonts (any more than usual) or network stuff does it? I assume I'll have to upgrade from Mojave at some point, but is now a good time?

My machine updated CC2020 over the weekend, and now I can't close out of anything. All the CC apps seem to have the red X disabled now. but Command-Q also doesn't work. I now have to go to File-->Quit to close it out. I'm gonna reboot my computer and see if that helps. The f***ing CC update screen is also stuck open - I can't get rid of it no matter what I do.

I have done this in FusionPro with scripts and if/and/then statements but have never done in InDesign. Is there a way through mail merge to author a statement to change the field name? To elaborate, I have a spreadsheet and some names say Telephone, some say Cell and some say Direct. Some people have 2 phones. Some 3. Some 1. If I write the field name in the text box, it will always be there, so other than create a new field in the spreadsheet for each descriptor, I don't know if there's a way.

Can anyone here convert a PageMaker file to InDesign for me?

Anyone else using this? It's pretty neat. I just needed two obscure fonts, and found them both in Google Fonts and downloaded the entire collection legally and free of charge. Noice!

Is it possible to tell what the font is supposed to be in a Power Point file? I got one to produce as a sign job for our sign shop, and it previews in Mac OS as a serif'd font, but Zamzar converts it to Courier (technically serif'd, but the preview looks more like Times), and when I open it in PowerPoint it changes to Verdana. I have no screenshot and no printout or pdf to compare to.