Forum Discussion
Nikolaus Yates
Apr 24, 2019Copper Contributor
Print Error 0x8007007e - Error while trying to print, preview does not work also only Edge Browser
Hello, while trying to print out any type of document, Windows 10, Browser Edge causes the following error: Auf Ihrem Drucker ist ein unerwartetes Konfigurationsproblem aufgetreten 0x8007007e Do...
- Dec 27, 2023
I just answered the earlier version of the same question, with the same feedback--too vague!--that Rodrigo_ gave you. Thank you for posting a copy of the workbook. Now that I've seen it, I will restate what I said before about keeping a single data source for that form.
The form is NOT filled in via macro. Why this is an XLSM file, I don't know, but you do NOT need a macro. It uses the classic VLOOKUP function to retrieve the data from any given row in that table. You enter the row number up in cell A1 (as the shared example has it) and for each entry in the form, VLOOKUP looks at a specific column. Here's the formula for the date. All of the subsequent formulas in the "Raptor Program" tab are essentially the same, except for that last '2' in this one. It tells VLOOKUP to go to column 2 of row 3 (the 3 coming from the reference in cell $A$1)...
=VLOOKUP($A$1,Black_Hills_Raptor_Data,2,FALSE)
Here's a reference where you can learn how VLOOKUP works.
What you'd be wise to do, however, is to clean up the tab containing the "raw data." Unless what you've shown has been greatly modified, it contains far too many blank rows. Make it an Excel Table, fill in the columns as needed. You do not need a new sheet for 2024. (It's not surprising that when you created one the formula didn't retrieve the data.) It could be modified so it would work with annual sheets, but that would just be putting a bandaid on the design issue. Instead, learn how VLOOKUP works, and put it to work retrieving data for that form from that single data sheet from now until forever.
Akshay_Mane
Jun 25, 2019Iron Contributor
Windows button + R to get to the Run screen
Type "spool"
Open "drivers"
Find folder "x64old" and open
Look for "printconfig.dll" in folder (might be in folder "3" within "x64old") and copy it (right click and "copy"), use search box in top right if needed
Go back to "drivers" folder and open "x64" folder
Paste the "printconfig.dll" into the same part of the "x64" folder (paste it in the "3" folder within it if that is where you found it in "x64old")
Restart computer and it should work (it will take a few extra seconds to spool up when you print your first document in Edge or Mail)
Worked great for me and I am not a big computer guy.
Good luck!!
Regards,
Akshay