Pages

Search

Excel Help Forum - Excel General: Shared workbook on a share drive

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Shared workbook on a share drive
I am having problems with a shared workbook on a shared drive, at least 5 people have access to file, some are not saving when they update and others go into sheet and update what has already been updated and then save creating duplicate work. Is there a better way or a way in the shared...

Excel Help Forum - Excel Charting & Pivots: Display values in horizontal axis in groups

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Display values in horizontal axis in groups
I would like to group the values on the horizontal axis into groups. The values of in hrs and the graph can get pretty wide if there are lots of hours. I was able to get the axis to change but wanted a specific range that is more customize. For example, instead of this range: 0 5 10 ...

Excel Help Forum - Excel General: How to change cell entry over many files

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to change cell entry over many files
Hi I have a spreadsheet that I use as a costing template. I have saved that workbook many times as a new file name - ie " save as ". I now have realised that I have made an error in a few cells or I need to add a new cell entry - ie: either spelling, or formula , or format. Is there a way that...

Excel Help Forum - Excel General: Concatenate Help!

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Concatenate Help!
I am trying to concatenate 24 cells of data so that I can combine them into one cell and then paste them into MS Word. I will do some qualitatative anaysis on them once in word. However When I use the concatenate function it cuts off the last few cells. I have also Tried using the & Function....

Excel Help Forum - Excel Charting & Pivots: Moving chart data to other sheet

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Moving chart data to other sheet
Hi guys, I have chart that forum guru Andy Pope helped me with. The 3rd sheet (Data) provides the information of the Y-positions. What I want to do is to be able to remove this data sheet and have all the information be pulled from the first sheet (Stakeholders) so that when filtering it...

Excel Help Forum - Excel General: [SOLVED] Question on blank cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 (coupon code ICU65OFF)
[SOLVED] Question on blank cell
Hi, to make a cell empty, we tend to use double quotation formula like: IF(..., ""). This assume that the target cell will have a blank value. But if test it use: =IF(ISBLANK(A1),"true","false") The result is false, which means that "" does not represent a blank cell. There is value there!...

Excel IT Pro Discussions Forum: Xl2007 - XL2010 References

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Xl2007 - XL2010 References

I have an appolication which I have written in Excel 2007 but I also use it on my laptop which has Excel 2010 on it.  I have to access the save files from both PCs.  The application Emails so has a reference to the Microsoft Outlook 12.0 Object Library.

When I open this file in XL2010 it works fine, 'magically' the reference getws changed to Microsoft Outlook 14.0 Object Library.

When re-open the file after it has been saved by XL2010 in XL2007 there is, understandably, a missing reference, to the Microsoft Outlook 14.0 Object Library.  What I have to do in untick the missing references and re-tick Microsoft Outlook 12.0 Object Library.  This is becoming tiresome.

Is there a way, other than I suppose copying the Microsoft Outlook 14.0 Object Library file onto my XL2007 PC, of configuring my application to work both in XL2007 and XL2010 without the reference tweak?

Subscribe to: Posts (Atom)