settings

I've had a PERSONAL workbook (binary worksheet) on my work computer for about 3 years, used to store macro functions that I can reference in all files and has worked great. I prefer to have the PERSONAL file hidden when Excel opens, however for some reason Excel will no longer open if I try to...

Hi There. I have a very annoying problem. When I scroll in a worksheet with the vertical scroll bar, the worksheet contents do not move with the bar. Once I release the mouse click from the vertical scroll bar, the worksheet jumps to that position. I would like the worksheet to move with the...

Hi all, I have an Excel sheet that I send to customers that has one intended circular reference. This is no issue when I check "limit iterations" box and set it to 1. However this setting is not saved to the workbook and each time a customer opens the workbook he/she gets the circular reference...

I created a document that is kept on a shared hard drive that needs to print exactly the same for all users. The print ranges are the same for most users, but when some users open it, the content takes up more space on the paper and pages are split. The page breaks do not move their relative...

Hello,I am working for a healthcare service provider. For keeping track of our actual time spent versus budgeted time, I would like to create a pivot table which contains this information. In this table, I would like to display the actual time spent on our tasks, in columns per month, with the...

I have several worksheets at work that are used by various users. The site ie is navigating to is an internal website. For most there is no need for the code to log them in as there currently logged in on another instance of IE. But a few users have to log in each time excel opens a new...

Hi all, Sorry if this is already out there and I missed it (in which case, please feel free to share the useful link:) ), but I was wondering if there was anyway to tie settings to a shared document. The details are as follows: I have an excel shared on a server with many other people. To...

Hi people, for some reason that i unknow, display columns changes from ABC to 123. Looking for some solution, I found this: Start > Excel Options > Formula > Working with Formula > Reference Style R1C1 and uncheck this option, when i do this "solve" the problem, but when i close application and...

Hey everyone So I have my settings for macros set in the trust center to 'disable macros all macros with notification'. When I open up a workbook that needs macros enabled, I'm not seeing the 'security warning' pop up where I can enable them myself? It used to show up when I opened workbooks...

Hello. I use Office Home and Business 2010, V14. It often happens that, when I open an existing spreadsheet to work in it, I can't use any of the functions on the ribbon. No problem selecting cells in the spreadsheet, and no problem closing it (red X in upper right corner) but no...

I've been creating spreadsheets to cost ingredients in recipes. Copying and pasting text from the Internet worked fine for four days, then yesterday everything I tried to paste into EXCEL seemed to parse on the letter O. Here's an example: <colgroup><col span="3"></colgroup><tbody>...

Hello, I have a workbook that is shared amongst various users and for two weeks running a user has update various cells with a comment and also inputted a value into the cell and saved the workbook. However when we check the report at a later date the comments have been removed. The workbook...

I'm using Excel 2010 with Windows 7. I'm new to macros. I've been recording macros and trying to assigning a keyboard shortcut in the Record Macro window but, they don't seem to stick. The macro keyboard shortcuts work with the first use but, don't work if I close Excel and try to use them...

I have a workbook to administrate a budget. When I startup my workbook I adjust some settings, e.g. budget_id. What is the best way to store these settings? Is it best to have a worksheet to store these settings with some named ranges and get and set with Range("budget_id").Value or is there...

Hello! I currently have an Excel file (using Excel 2007 and sharing turned on) with track changes enabled. All of the numeric values in the worksheet are set to 4 decimal places. However, when we make a change to one of the values, the track change "hover-over" note, as well as the change...

In Excel 2010 a default safeguard is in place that sets all Excel files received by e-mail to manual recalculation instead of automatic recalculation. I know how to change each sheet manually (File, Options, Formulas, Automatic Calculation) but is there a way to remove this safety feature...

I have created a file with multiple sheets that different locations access through our public drive. Each sheet has a different print setting. I can get the form to work in my office but as soon as another office uses the form, the print settings are gone. I tried to create macros and even those...

Hi I have a problem running VBA code. My colleague has programmed functions (modules and classes), but it simply does not work for me. I know that the code is ok, but maybe I got some Excel properties wrong...? The cell calling the function simply returns '#VALUE!'. Do I have to allow for the...

I was asked by a co-worker to try to print an Excel worksheet in landscape rather than portrait as he was having bother getting it to do so. I tried and could not either. The file is an old file created on an older PC. We have been printing this correctly each month. However what changed was our...

I have created a spreadsheet with macros. I have created a digital signature and have signed the VB code. I have distributed the spreadsheet to 30 people and have added myself as a trusted publisher to 28 of those computers. I have done this by opening the signed spreadsheet on their computer...