view

  1. B

    Calculating Variances (Value and Percent) in Pivot (not using power pivot) - is it possible?

    I have financial data that I need to show variances against a number of dimensions. I need this in pivot so that I can use filters to create automatic views for different audiences (e.g. Divisions and Heads of Areas). In the pivot there are roll ups, so example income as a level with sub level...
  2. D

    Position the "hyperlinked cell" in the middle for easy view

    Dear Professionals, I have a formula here that can target the wanted cell in the desired sheet, but it doesnt lock on the position for better view in the middle of window. Please help. =HYPERLINK("#"&CELL("address",INDEX(Pivot!BL:BL,MATCH(MID(B358,1,6),Pivot!BL:BL,0))),MID(B358,1,6)) From...
  3. T

    disable design view in Access

    I am trying to disable the design view so user cannot make any changes. Greatly appreciate if you can help or what other option I can do to protect my database from being modified. Thank you!
  4. gheyman

    Access: Design view problem - only showing SQL

    I am trying to see my query in Design View, but its only coming up in SQL (I am clicking Design View not SQL View). I'm not that good at SQL so I need to see it in Design view. Anyone know how to fix this? Thanks
  5. M

    Can you save a sort in a Custom View?

    Okay, I've sorted my sheet the want want to view something, and have saved it as a Custom View. When I remove all of the filters, and test the view by selecting it, everything works except for the sort. I'd like for it to sort from smallest (number) to biggest. Is this possible?
  6. N

    Password Protecting Worksheet from Viewing or Alternatives

    Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...
  7. B

    Can I Freeze a Slicer

    I have a date slicer connected to a pivot table with over 3000 rows so I was wondering if it was possible to freeze it like I can with an excel row? I have the top row of my sheet frozen so I can see the column headers while I scroll but my slicer moves out of view when I scroll. I thought it...
  8. Z

    cell format

    hello, i would like to know if i can preserve excel cell format when using any lookup formula, i have a chart and want to view sales by quantity/value or percentage based on slicer selection. the method that i’m using currently allows me to view any of the above with 1 type of format not based...
  9. ACommandLineKindaGuy

    How to disable Page View buttons (Normal, Page Layout, Page Break View) next to Zoom on status bar

    Amazing how impossible it is to phrase this search on Google... I'm not interested in manipulating or viewing page breaks. All I want is to be in normal view. I am not interested in workarounds similar to attaching If ActiveWindow.View <> xlNormalView Then ActiveWindow.View = xlNormalView to...
  10. gheyman

    Access Fields disapear in Query

    My fields disappeared in my query after I unchecked the Show box. I don't mean they don't show data view, I mean when I go back to the design view they are all gone. What happened?
  11. E

    Using VBA to lookup a value and write back to that row in a different sheet

    Forgive me here guys. I'm completely self taught but have zero knowledge of visual basic and have come up against a problem that I believe can only be solved by visual basic I have a worksheet of customer information called "data" I then have another worksheet called "Agent View" The agent...
  12. C

    Using Calculate Field in Same Query

    Hello, I have a very limited knowledge of Access and am struggling through and enjoying creating my first database. When in query design view, I created a field by entering the following formula into the field region: Lab$: [LabHours]*([CrewRate]+[OHRate]) So when I switch to datasheet view...
  13. E

    Browser Page Refresh: Reflect new data after scheduled refresh

    Hi, Does any one knows if there is a way to refresh the Chrome view of a power bi report in the service after the schedule refresh? (without using Chrome add ins) [ i have a report that is presented constantly on a tv and refreshes once a hour or so, the view does not update after the...
  14. kweaver

    Error opening file after sorting, saving, and closing

    I have an Excel workbook with a tab named "Master". I have a sorting button that calls this routine: Sub SortByEmpNo() Sheets("Master").Activate With ActiveSheet.Sort .SortFields.Add Key:=Range("A10"), Order:=xlAscending .SetRange Range("A10:G1013") .Header = xlYes .Apply End With End...
  15. S

    userform list view with multiple filters

    Hi all, I hope that what I’m about to ask doesn’t seem too difficult to picture, but I’ll try to put it out as plainly as I can for you to see what I’m getting at. I run a Stock Control workbook containing a very large dataset spread over about 20+ worksheets – let’s call it “Stock KPIs –...
  16. R

    Hide Columns and Filter in a custom way

    Hello: I have many columns from left to right in my spreadsheet. I find myself always hiding columns to view data then un-hiding columns to view other data. Is there a way I can set up a macro or a saved quick or option so I can set up different views? In other words can I for example view #1...
  17. A

    Select Value from dropdown list and display the range of cells from the worksheet

    Hello, I want to create a dropdown list with some text and after the selection of the text with the submit button, I want to display the user to view the range of cell in the present worksheet. To be more precise : Ex: the user select the the value C1, which is a table in the work sheet out of...
  18. P

    VBA to expand pivot table

    Hi, I have 24 pivots in sheet1 and in sheet2 I have a dashboard which will have the numbers from the Pivot output. I have used GETPIVOTDATA to fetch the data from Pivot to my dashboard Table. I have 5 slicers connected to all the 24 pivots. I have years as data in one of the pivot as columns...
  19. A

    Put a value to a cell only if two values of two other columns are the same

    Hello everyone, i tried to search and find what I am looking for but with no success probably because I cannot describe it very well. I will try to explain what I need with a picture. Thanks for your assistance in advance.
  20. V

    Need one help when filtering to data

    Hi Experts, Please assist me in adding one more knowledge here. Whenever we filter to headings, i observed that suppose if my cell selection on col AO or any other cell, if i use Ctrl+Shft+L for filter, sheet view jumps to left i.e. col A side.. How do i keep freeze this view on my selected...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top