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
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
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
Mogul Technology 