view

Hello All. if I select a cellor cells to add to the watch window, the columns added are: Book, Sheet, Name,Cell, Value, Formula Because I'm onlyinterested in the value, and as I don't want the watch window to take up a lotof unnecessary space. I reduce the width of the window, and scroll to...

I have a pivot table and have the total amount in dollars, and the total quantity in the Values. This displays the data like this Row 1 Amount | Quantity Amount | Quantity Amount | Quantity Amount | Quantity so for each month there is an Amount and Quantity. I need to display the pivot...

Re: Open and view external file Hi Everyone Can anyone help with the following: Is it at all possible to place a file location into a cell select this cell and open and view file then return to Excel. ie say I wanted to access a PDF or Word file view contents then return to Excel and close...

Hey guys, let's say you had to compare a very large group of categories, each with a set of defined traits. The goal is to compare every category against every other category and identify the pairs that are MOST SIMILAR in terms of their trait set. That is, all those category pairs that are...

Hi All, When I scrape a file from the web it comes in "protected view". When I use the recorder for this being unprotected. I get: application.activeprotectedview.edit=false. When I run this on a new file I get run time error 91. Not sure exactly what object I'm supposed to define and set. Help...

Hi, i have an Excel file here on shared drive when i view the file on my computer with all the formulas i get the Report with correct values displayed, but when i view this on another Computer. the values Change and i get different values displayed, not very big difference but maybe 1-5%...

Hi All I have Log In Security within a Workbook which is activated by Clicking a button [CommandButton2]. However, what I need is, if a User clicks the other button [CommandButton1] then it will open the workbook and all sheets [except Admin & Lists] so they can view the content. I cannot work...

I've been able to successfully unprotect worksheets, but not the entire workbook. My problem is that there is a worksheet that is hidden, and I need to view the formulas from that worksheet. I'm able to see the contents of that by entering a formula on an unhidden worksheet (and from those...

Hi I have a custom view named "All Routes List" I'm trying to activate this view when the worksheet named "Analysis" is opened. I've tried inserting the below code in the worksheet: Private Sub Worksheet_Activate() CustomViews("All Routes List").Show End Sub And it returns "Compile error -...

Hi there, I just upgraded from Excel 2010 to Excel 2016 and can’t work out some of the differences. I customize the Home tab by re-positioning “Editing” and “Cells” but when I restart Excel the tab has reverted to the default positioning? When I split the view each workbook has it’s own...

Hi all, Can I please ask for some help to toggle the view of column H I would like to press a button to hide column H and then if pressed again unhide column H so on Thanks

Iam unable to see the code in developer view.

I have loaded Excel for the nth time today and I cannot now access the VB Editor. I have the Excel and VB tabs visible. Mouse depress on the VB tab causes the active cell highlighted border to disappear and reappear when mouse released. Trust Settings are fine. I can create macros but not...

Hello everybody, this is my first post It is not actually a technical question BUT please tell me there is a way to go back to the classic view of MS Excel from Excel 365... Awful and Outlook is even worse Thanks for any advice, I almost can't work anymore

Is there a way to stop excel from displaying a "Watermark Type" text when viewing document in page or layout view? I have a named range that appears like watermark when I view the document at less than 40% zoom. It goes away if I delete the named Range or if I view at 40% or higher zoom The...

Hi I have this formula in a cell =CHAR(127)&CHAR(127)&CHAR(127)&"testing" so I got [][][]testing When I print preview (I do not have a printer), I can see all these characters and testing in print view window? Does that mean even when I view them in Print Preview that means they still will not...

Hello: I have an index match formula that I have been using but now I need to add a concat to it. I have been reading tutorials but cant find my formula error. Original Formula: = INDEX('Date View - ALL'! $A$5:$AM$596,MATCH('Process Assumption'!$F7,'Date View-ALL'$L$5:$L$596,0),MATCH('Process...

CREATE VIEW SKI_CUST1 AS SELECT FirstName, LastName, Street, Citi, State, Zipcode, InvoiceNumber FROM CUSTOMER JOIN INVOICE USING (CustomerID) ; While running Query gettig an error massage "Syntax error in CREATE TABLE statement" and curser shows/holds "VIEW" CREATE VIEW SKI_CUST1 AS

Hi while creting VIEW in SQL getting an error "Syntax error in CREATE TABLE statement" Below are my Query CREATE VIEW NH_CUST AS SELECT CUSTOMER.FirstName , CUSTOMER.LasName , CUSTOMER.Phone , FROM CUSTOMER WHERE CUSTOMER.State = 'NH' ;

Hi guys Any way to prevent "Personal views" on Excel? My workteam have 15 people working on several Shared Workbooks and all users have Office Professional Plus 2016 on W10.. I have defined that all files have the freeze pane at "C2", but there are some people that insists on unfreeze...