Category Archives: Excel Tips

Copying Worksheets to Other Workbooks – Shapes causing unwanted links

I have a project that copies a series of worksheets from other files to a consolidation workbook.  After the consolidation workbook is saved and closed, when it is reopened, the following message appears: This workbook contains links to other data … Continue reading

Posted in Excel Tips, VBA Code | Leave a comment

Copying Worksheets from one Workbook to Another – Error 1004

I was working on a project using Excel 2010  where I had to copy entire worksheets from one workbook to another.  I was doing this through some vba code.  When I attempted to save the target file, I would get … Continue reading

Posted in Excel Tips, VBA Code | Leave a comment

Importing Excel into Access. Sometimes Access is too smart for its own good.

Ever try to import an Excel file into Access and find that some records were not imported because they didn’t match the field type (text, integer)?  Access tries to predict the field type based on the data it sees and … Continue reading

Aside | Posted on by | Tagged , | Leave a comment

Lost those leading zeros in Excel / Access?

You’ve imported data into your Excel sheet or Access application and those important leading zeros got lost.  For example, your 5 digit zip code (04231) is now only 4 digits (4231). Here’s a simple formula to get back the zeros: … Continue reading

Posted in Access Tips, Excel Tips | Leave a comment

Len Function – Does not work the same in Excel and SQL Server!

A colleague of mine was having a problem with Excel.  He had imported data from a SQL Server database.  When he created a pivot table with the data, one of the data elements displayed twice.  For example, let’s say the field … Continue reading

Posted in Excel Tips | Leave a comment

Placing the Worksheet Name in a cell in Excel

There are times when you have a large number of worksheets in your Excel Workbook and you want the Worksheet name to also be included in a cell on the Worksheet.  This may be for presentation purposes or just simply to place a … Continue reading

Posted in Excel Tips | Leave a comment