Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jlockley
  • Content: Threads
  • Order by date
  1. jlockley

    Excel: Importing European account information (German bank spreadsheets are the worst.).

    I've just spent a week figuring out how to best import German and Spanish bank statements into Excel in America. Some European statements import well, others less so. (In this case Deutsche Bank and Banco Sabadell). As I've noticed in researching the problem that is not uncommon, I decided to...
  2. jlockley

    MS Office 365. imported columns will not resolve as nrs

    In every downloaded account spread sheet imported in utf8 (other formats also attempted) I am unable to get any numbers to calculate. Formulas return zero. Attempted so far Using regular interfaces to change format to numerical. Special paste as values. Special paste multiplying all column by 1...
  3. jlockley

    Updates compromise windows common shell DLL. Cannot hinder updates.

    One of a large number of recently installed updates is corrupting my system. Late last night Skype stopped working and I could not connect a new Outlook account due to a failing windows common shell DLL. An events check revealed an update barrage shortly prior to the incident. Restoring to a...
  4. jlockley

    Concatenate? Add? Joining cells in Excel so as to replace cells that don't line up.

    I have an account download with unaligned cells. Row numbers 72-75 will have a single date cell, but the transaction description in the next column is divided into two or three rows, the date may be one full height column or two or three. You can see it in the attachment better than I can...
  5. jlockley

    Excel paste special missing options

    Frequently but not consistently the paste special interface on Excel only provides the choices of Unicode or text This can happen with the same data on the same spread sheet. Skype for Firefox is not installed, Excel has no add-ons and has been tested in Safe Mode. All data is in numeric format...
  6. jlockley

    Changing pasted cell format to numeric does not work.

    Cells were cut and paste from the Berlin Sparkasse web site. Using the format option they were then reformatted as numeric general. A simple formula (=A1*$C$1 , where the value of C1 was the conversion factor for Euros to dollars) would not function. The suggested solutions, using the error tab...
  7. jlockley

    Outlook 2010 Past Special functions missing.

    Instead of the usual paste special options an interface with a choice of formats appears. I am trying to multiply cells in a column by a constant, which is easily achieved via paste special. I have exhausted the following fixes: Skype turned off Skype click to something removed. Start Excel in...
  8. jlockley

    Outlook vs Mail Windows 8 w/Office Home and Student

    Having a little trouble setting up a new Lenovo with Windows 8. Aside from the fact that Microsoft has determined that everything I do is on the web and offers a screen full of "apps" (What happened to programs) I can't use with the assumption that I will always be connected (I won't) I cannot...
  9. jlockley

    Virus? (posted in Windows, but perhaps it belongs here)

    I am having extremely odd issues with Windows. Use Avast, thought I had a firewall on the router (which appears not to be running..oddly and unfortunately) and windows firewall, a few other precautions. Do very little risky surfing, but did download DriveClone in a moment of desperation. At...
  10. jlockley

    Windows 7 slows or freezes, will not run more than one program, programs will not close.

    At about noon today on reboot Windows 7 would not open Word, then would not open other programs. It boots quickly, but once Windows is open it freezes or slows on accessing the start menu or on trying to open any program or access the task manager or Control Panel. Other symptoms: Non...
  11. jlockley

    How do I find range of servers for a spam server (Beyond the Newtwork USA).

    We have been found by a Ukranian Spam server/provider of space for spammers named Beyond the Network USA. My mail server uses an RBL but these (satellite) servers are only sporadically identified - surprising considering the extent of their badness reported across the web. (Lots or reports of...
  12. jlockley

    During multiplr Outlook [link http:

    During multiplr Outlook challengesI have set up the same Outlook exchange account several times, after making a secure copy of the .ost file. the new setups however create a .pst data file an will not recognize the .ost file. Since I need to have the mail left on the server, I believe the ,ost...
  13. jlockley

    continual windows credentials popups prevent outlook access / exchange setup

    After migrating data from a failing drive and "successfully" authenticating Outlook 2010 Trying to access server sent up repeated stand-up-man "Windows Security" credentials popups, with the correct log-in name but false password. Entering correct password and checking "remember password" has no...
  14. jlockley

    vpn process Ipad to Windows 7?

    I have a desktop based software i do not want to put on a remote server (it may not even be possible). I would like to access the desktop from Ipad. I hear this is possible, but Ihave not yet found the (vpn?) solution. Suggestions would be appreciatrd.
  15. jlockley

    Can't access bios, MB won't recognize second drive,

    ASUS P8H77-M CSM new with 8GB Ram, 2 (in theory) SeaGate 1TB HD's . Issues: 1) Del does not bring up bios. Setup only accessible if cmos reset, then via F1. 2) Flash screen freezes 3) If only boot drive on board, long flash screen. Boot to W7 takes about 8 or 9 minutes (really long) 4) Will not...
  16. jlockley

    Bad disk warning but chckdsk shows no bad sectors. (condition llisted as good in system manager)

    After a month's absence I returned to a white warning on a blsck screen that the year or so old boot drive (SEAGATE - BARRACUDA 1TB (1000-GB) 7200RPM) was bad, reboot, backup and replace. (not a direct quote). Chckdsk / Disk Scan run after reboot shows the drive to be in good condition with no...
  17. jlockley

    in document search Word '10

    Have small hope, but thought I'd ask (you all know everything). I need to search in a long code document (transferred to work for simplicity's sake) for the validation of a field requested in a query. That means searching for a previous instance of the exact term. I notice that there is no more...
  18. jlockley

    Merge Doc (MSO 2010) does not see all recordsin Access 2K sourc fille

    I am running Access 2000 and Home Office 2010 on Windows 7. I have been having considerable challenges with merges (for instance changing the data source..there must be a way?) The merge interface only shows 7 of the twelve records, excluding those recently added. The file was saved and was not...
  19. jlockley

    W7 Search solution

    After moaning about Windows 7 search for some time I think I have found a solution. Windows 7 search is an abomination, crashes my machine, gives me a list of hundreds of mp3 files (not necessarily songs) when i search for a file named "music" and can't find idapi32.*** with both hands...
  20. jlockley

    deactivate an ini file?

    I am fighting Paradox on a new W7Pro installation; The issue is that Paradox has two files which reset the default file locations every time it is shut down. They are pdxregcln.exe and pdxregcln.ini. (Paradox default settings throw all files into the great My documents cloaca. I need a distinct...

Part and Inventory Search

Back
Top