Can someone assit me with which formula to use to add cells together that contain the less than symbol for numbers from lab analysis results? I have attached a snip it for reference. 

Need to know ASAP.

MPTotal each Row for four columns

​Can someone assit me with which formula to use to add cells together that contain the less than symbol for numbers from lab analysis results? I have attached a snip it for reference.  Need to know ASAP. MPTotal each Row for four columns   Read More

​

Is there a way to bulk edit viewing permissions in the properties of folders while in the search query? So far, I am noticing it will only work if I am *not* in the search query. These would not be unique permissions, rather each folder will have the same viewing permissions/users.

​Is there a way to bulk edit viewing permissions in the properties of folders while in the search query? So far, I am noticing it will only work if I am *not* in the search query. These would not be unique permissions, rather each folder will have the same viewing permissions/users.  Read More

​

Cowrie is an advanced honeypot designed to emulate SSH (Secure Shell) and Telnet services to attract, detect, and analyse malicious activities. As a type of cybersecurity tool, a honeypot like Cowrie is used to create a controlled environment that mimics real systems to lure attackers. Once attackers interact with Cowrie, their activities are logged(json), providing valuable insights into their methods and motives.

Key Features of Cowrie

SSH and Telnet Emulation: Cowrie simulates SSH and Telnet services, which are commonly targeted by attackers seeking unauthorized access to systems.
Detailed Logging: It captures detailed logs of attempted commands, executed commands, and interaction patterns. This helps in understanding attack methodologies and tools used by attackers.
File and Command Logging: Besides logging commands, Cowrie also logs files uploaded and downloaded by attackers, offering a comprehensive view of their activities.
Support for Interactive Sessions: Cowrie can simulate interactive command-line sessions, allowing it to capture more detailed information about attacker behaviour.
Dynamic Configuration: The configuration of Cowrie can be tailored to mimic various environments and setups, enhancing its effectiveness in different scenarios.

Why Use Cowrie?

Threat Intelligence
Cowrie provides valuable insights into attack trends and techniques. By observing and analysing the interactions of attackers with the honeypot, security professionals can gather information on attack vectors, tools, and methodologies. This intelligence is crucial for improving security measures and defenses.

Detection of Unknown Threats
Honeypots like Cowrie can detect and log unknown or emerging threats that might not be caught by traditional security measures. Since attackers are drawn to the honeypot, it can uncover new vulnerabilities and attack methods before they impact real systems.

Improved Security Posture:
By studying the data collected from Cowrie, organizations can enhance their security posture. This includes refining intrusion detection systems (IDS), updating firewall rules, and improving overall security policies based on real-world data collected from the honeypot.

Low Risk Deployment:
Since Cowrie is designed to simulate services rather than be a real production environment, the risks associated with it are contained. Any malicious activity targeting the honeypot does not affect actual production systems, making it a safe and controlled way to study attacks.

Conclusion

Cowrie is a powerful and versatile tool for cybersecurity professionals looking to understand and combat malicious activities targeting SSH and Telnet services. By deploying Cowrie, organizations can gain crucial insights into attack patterns, detect emerging threats, and improve their overall security posture while maintaining a low-risk environment for research and analysis.

Integrating Cowrie honeypot with Microsoft Sentinel (SIEM & SOAR)

Integrating Cowrie with Microsoft Sentinel brings several benefits for enhancing cybersecurity operations. Microsoft Sentinel is a cloud-native Security Information and Event Management (SIEM) service that provides intelligent security analytics and threat intelligence across the enterprise. By combining Cowrie’s detailed honeypot data with Sentinel’s advanced analytics and automation capabilities, organizations can achieve a more comprehensive and effective security posture.
Analytical Rules, Threat Hunting, Automation, Workbooks, Custom Parsers.

Step-by-Step Guide to Install Cowrie on Linux:

Github: GitHub – cowrie/cowrie: Cowrie SSH/Telnet Honeypot https://cowrie.readthedocs.io

Update Your System

Start by updating your package lists and upgrading existing packages:

sudo apt update && sudo apt upgrade -y

Install Required Dependencies

Install the necessary packages and libraries for Cowrie:

sudo apt install -y python3-pip python3-venv python3-dev libssl-dev libffi-dev build-essential git

Create a Cowrie User

Create a dedicated user to run Cowrie:

sudo adduser –disabled-password –gecos ‘Cowrie’ cowrie

Switch to the Cowrie User

Switch to the Cowrie user account:

sudo -u cowrie -i

Clone the Cowrie Repository

Clone the Cowrie GitHub repository to the Cowrie user’s home directory:

git clone https://github.com/cowrie/cowrie.git

Navigate into the Cowrie directory:

cd cowrie

Set Up the Python Virtual Environment

Create and activate a Python virtual environment within the Cowrie directory:

python3 -m venv cowrie-env

source cowrie-env/bin/activate

Install Cowrie’s Python Dependencies

Install the required Python packages using pip:

pip install -r requirements.txt

Configure Cowrie

Copy the sample configuration files to create your own configuration:

cp cowrie.cfg.sample cowrie.cfg

cp userdb.txt.sample userdb.txt

Edit cowrie.cfg to adjust settings as needed. For basic usage, you might not need to make changes initially. Use a text editor like nano:

nano cowrie.cfg

Start Cowrie

Start Cowrie using the provided startup script:

bin/cowrie start

You can stop Cowrie with:

bin/cowrie stop

And check its status with:

bin/cowrie status

Verify the Installation

To ensure Cowrie is running, you can check the logs located in the cowrie/log directory:

tail -f log/cowrie.log

Accessing the cowrie using windows Command prompt and verifying logs flow.

Full potential and see how it captures and logs attacker activity

Connect to Cowrie

To interact with Cowrie, connect to it using SSH or Telnet. For example, if Cowrie is configured to listen on port 2222 for SSH:

Explore Cowrie’s Features
Test Authentication

Try Different Usernames and Passwords: Cowrie will log any attempted logins, including failed attempts. Use common usernames like root, admin, or user, and various passwords to see how Cowrie records these attempts.

ssh -p 2222 root@ 172.210.56.197
ssh -p 2222 admin@ 172.210.56.197
ssh -p 2222 user@ 172.210.56.197

Check Logs: Cowrie logs authentication attempts in its log files. Monitor var/log/cowrie.log to see how these attempts are recorded.

Execute Commands

Try Common Commands: Once logged in, you can execute common Unix commands to simulate normal or malicious activity. For example: Ls, whoami, uname -a

Upload Files

Use SCP or SFTP (if configured): If Cowrie is set up to handle SCP or SFTP, you can try uploading files:
scp -P 2222 localfile.txt user@172.210.56.197:/tmp

Test Network Interactions

Check for Open Ports: Use tools like nmap to scan Cowrie and verify which ports are open
nmap -p- 172.210.56.197

Leveraging Microsoft Sentinel with Cowrie: Parsers

To parse and normalize Cowrie logs in Microsoft Sentinel using Kusto Query Language (KQL), you can create a query that extracts and organizes the relevant information from the raw log data. Below is an example KQL query that parses the Cowrie logs, assuming the logs are stored in a custom log type (e.g., newCowrie_CL).

KQL Query for Parsing Cowrie Logs

The following KQL query will parse the log entries and present them in a normalized format. Adjust the field names based on your actual log structure and requirements.

// Query to normalize and extract information from Cowrie logs

newCowrie_CL
| extend EventID = tostring(parse_json(RawData).eventid),
         URL = tostring(parse_json(RawData).url),
         Outfile = tostring(parse_json(RawData).outfile),
         SHA256 = tostring(parse_json(RawData).shasum),
         Sensor = tostring(parse_json(RawData).sensor),
         Message = tostring(parse_json(RawData).message),
        SourceIP = tostring(parse_json(RawData).src_ip),
         SessionID = tostring(parse_json(RawData).session)
| project EventID, URL, Outfile, SHA256, Sensor, Message, SourceIP, SessionID

Leveraging Microsoft Sentinel with Cowrie: Analytical Rules

Creating analytical rules in Microsoft Sentinel based on Cowrie logs can provide valuable insights into security threats and activities captured by the honeypot. Below are some prominent use cases and corresponding KQL queries that can be used to create these analytical rules:

Detect Suspicious File Downloads

Use Case: Identify instances where files were downloaded from suspicious or known malicious URLs.

KQL Query:
newCowrie_CL
| extend EventID = tostring(parse_json(RawData).eventid),
         URL = tostring(parse_json(RawData).url),
         SourceIP = tostring(parse_json(RawData).src_ip)
| where EventID == “cowrie.session.file_download”
| where URL contains “malicious-site.com” or URL contains “suspicious”
| project  SourceIP, URL

Alert on High Number of Failed Login Attempts

Use Case: Detect brute-force or password-guessing attacks by monitoring a high volume of failed login attempts.

KQL Query:

newCowrie_CL
| extend EventID = tostring(parse_json(RawData).eventid),
         SourceIP = tostring(parse_json(RawData).src_ip)
| where EventID == “cowrie.login.failed”
| summarize FailedAttempts = count() by SourceIP
| where FailedAttempts > 2
| project  SourceIP, FailedAttempts
| order by FailedAttempts desc

Monitor Unusual File Execution

Use Case: Detect attempts to execute files or scripts that are unusual or not typical for the environment.

newCowrie_CL
| extend EventID = tostring(parse_json(RawData).eventid),
         Command = tostring(parse_json(RawData).command)
         SourceIP = tostring(parse_json(RawData).src_ip)
| where EventID == “cowrie.session.command”
| where Command contains “wget” or Command contains “curl” or Command contains “chmod +x”
| project  SourceIP, Command

Detect File Uploads and Downloads

Use Case: Monitor file uploads and downloads to detect potential exfiltration or data theft activities.

newCowrie_CL
| extend EventID = tostring(parse_json(RawData).eventid),
         URL = tostring(parse_json(RawData).url),
         SourceIP = tostring(parse_json(RawData).src_ip),
         Outfile = tostring(parse_json(RawData).outfile)
| where EventID in (“cowrie.session.file_upload”, “cowrie.session.file_download”)
| project  EventID, SourceIP, URL, Outfile

Rule Description: This rule monitors file upload and download activities, helping to identify potentially malicious file transfers.

Detect Connection Events

Use Case: Track connection events to detect unusual patterns in access or possible reconnaissance activity.

newCowrie_CL
| extend EventID = tostring(parse_json(RawData).eventid),
         SourceIP = tostring(parse_json(RawData).src_ip)
| where EventID == “cowrie.session.closed”
| project SourceIP

Leveraging Microsoft Sentinel with Cowrie: Workbooks

Azure Monitor Workbook for Cowrie logs involve using Kusto Query Language (KQL) to extract and visualize various aspects of the data. Here’s a guide to building a comprehensive and dynamic Workbook that includes various visualizations and insights from your Cowrie logs.

Overview Dashboard

Purpose: Provides a high-level summary of all key metrics.

newCowrie_CL
| extend EventID = tostring(parse_json(RawData).eventid)
| summarize
    TotalEvents = count(),
    TotalSuccessfulLogins = countif(EventID == “cowrie.login.success”),
    TotalFailedLogins = countif(EventID == “cowrie.login.failed”),
    TotalFileUploads = countif(EventID == “cowrie.session.file_upload”),
    TotalFileDownloads = countif(EventID == “cowrie.session.file_download”),
    TotalCommands = countif(EventID == “cowrie.command.input”),
    TotalSessionClosed = countif(EventID == “cowrie.session.closed”),
    TotalSessionConnect = countif(EventID == ” cowrie.session.connect “)
| project
    TotalEvents,
    TotalSuccessfulLogins,
    TotalFailedLogins,
    TotalFileUploads,
    TotalFileDownloads,
    TotalCommands,
    TotalSessionClosed,
    TotalSessionConnect

Microsoft Global Hackathon-2024- Cowrie-Sentinel Integration:
Introduction
Technical Deep Dive

Hackathon 2024- Cowrie-Sentinel Integratio (20-09-2024 22-09-17).wmv

​Microsoft Tech Community – Latest Blogs –Read More 

Sharing a problem and solution which I believe might be helpful.

I’ve been working for a while on coming up with a way to sort and rank a list of customer / item / other identifier fields which are part of a dynamic array (orange data). The goal was create a counter beginning at 1 for each customer/item combination, which would reset when a new item combination was identified, giving me the Customer-Item Counter in the green column. I wanted to avoid the need to drag formulas next to the dynamic array (could use “=IF(C2=C1,B1+1,1)” and copy paste). 

I thought that Sequence would likely solve this with some creativity, but was unsuccessful in triggering it to reset at zero when the Customer-Item field changed. After looking over forums for a while, I stumbled upon this post about circular references in dynamic arrays, where Patrick2788 recommended the Scan function. With a very slight modification to his answer, as well as the addition of a dynamic helper column, the solution was identified. Patrick, you’re a life-saver.

The helper, which is the Dynamic Offset Comparison formula, is 

=IF((OFFSET(C2:C26,-1,0,COUNTA(C2:C26),1)=C2:C26),1,0)

The Dynamic Counter formula, which is really the heart of the problem, is

=SCAN(1,H2#,LAMBDA(v,a,a+v*a))+1

The Dynamic Rank is simply concatenating those two formula, and then there’s a check to show it working.

Would be curious to hear if this is helpful, and alternatives to solving this. I’ve only been using dynamic ranges for a few months, and am still very green with LAMBDA, but I’m excited to learn more ways to use it.

​Sharing a problem and solution which I believe might be helpful. I’ve been working for a while on coming up with a way to sort and rank a list of customer / item / other identifier fields which are part of a dynamic array (orange data). The goal was create a counter beginning at 1 for each customer/item combination, which would reset when a new item combination was identified, giving me the Customer-Item Counter in the green column. I wanted to avoid the need to drag formulas next to the dynamic array (could use “=IF(C2=C1,B1+1,1)” and copy paste).  I thought that Sequence would likely solve this with some creativity, but was unsuccessful in triggering it to reset at zero when the Customer-Item field changed. After looking over forums for a while, I stumbled upon this post about circular references in dynamic arrays, where Patrick2788 recommended the Scan function. With a very slight modification to his answer, as well as the addition of a dynamic helper column, the solution was identified. Patrick, you’re a life-saver.  The helper, which is the Dynamic Offset Comparison formula, is =IF((OFFSET(C2:C26,-1,0,COUNTA(C2:C26),1)=C2:C26),1,0) The Dynamic Counter formula, which is really the heart of the problem, is=SCAN(1,H2#,LAMBDA(v,a,a+v*a))+1 The Dynamic Rank is simply concatenating those two formula, and then there’s a check to show it working. Would be curious to hear if this is helpful, and alternatives to solving this. I’ve only been using dynamic ranges for a few months, and am still very green with LAMBDA, but I’m excited to learn more ways to use it.   Read More

​

I’ve been struggling for the past month to get my website indexed by Bing, despite my best efforts. The site includes a proper robots.txt file, and a sitemap, and is successfully indexed by Google. I’ve also used the IndexNow tool and made sure to follow Bing’s Webmaster Guidelines closely. These guidelines serve as a comprehensive roadmap, yet Bing still hasn’t indexed the site. I’ve tried various troubleshooting steps, from optimizing the site structure to ensuring there are no crawl errors, but the issue remains unresolved.

​I’ve been struggling for the past month to get my website indexed by Bing, despite my best efforts. The site includes a proper robots.txt file, and a sitemap, and is successfully indexed by Google. I’ve also used the IndexNow tool and made sure to follow Bing’s Webmaster Guidelines closely. These guidelines serve as a comprehensive roadmap, yet Bing still hasn’t indexed the site. I’ve tried various troubleshooting steps, from optimizing the site structure to ensuring there are no crawl errors, but the issue remains unresolved.  Read More

​

Surface devices are crafted to deliver a premium and versatile experience, whether you’re working from home, in the office, or on the go. Each environment presents unique challenges for display readability, particularly due to reflections and glare from ambient light sources. 

Based on feedback and extensive user testing, we set out to develop a solution to minimize unwanted reflections while maintaining the clarity and contrast of your display.  

We wanted to design an experience that minimized distracting reflections and delivered on key experiences that our users expect including: 

Integrating anti-reflective (AR) technology with touch and pen experiences without compromising responsiveness and accuracy.
Ensuring the durability of the AR technology and to protect against scratches, fingerprints and other environmental factors.
Maintaining the color fidelity and uniformity of the display across the entire screen and calibrating it to industry standards.
Optimizing the optical performance of the AR coating and avoid any interference with the IR and RGB cameras used for Windows Hello and other features.

In this blog post, we’ll explore these challenges in more detail and show how we addressed them with solutions in Surface Pro 10 for Business and Surface Laptop 6 for Business.

What is anti-reflective technology?

There are different types of glare suppression technology, such as anti-glare and anti-reflective (AR) solutions.

Anti-glare technology works by creating a microscale uneven display surface, scattering light that hits the display, reducing harsh reflections and creating a matte finish.
Anti-reflective technology reduces the amount of light bouncing off the display by applying a thin coating that minimizes reflections.  By minimizing reflections, anti-reflective technology can enhance the visibility and clarity of the screen content, especially in bright or variable lighting conditions.

Surface Pro 10 showing the results of AR coating on the right side

Benefits of anti-reflective technology on Surface Pro 10 & Surface Laptop 6

With Surface Pro 10 and Surface Laptop 6, we sought to bring even more value to our commercial customers by adding AR technology to the displays. This new technology improved the experience in using our devices by delivering:

Improved readability: AR technology enhances display readability by reducing reflections and glare, making it easier to see in various lighting conditions—whether it’s bright daylight, cloudy skies, office lighting, or at night in your bedroom or on an airplane. Readability largely depends on contrast, a key quality factor that we meticulously measure and optimize.
Enhanced color perception: By reducing the reflections and glare, anti-reflective technology improves the perceived color of the display, as the ambient light can alter the hue, saturation and brightness of the screen content. Color perception is another critical quality factor that we strive to deliver.
Compliance with regulations: Some organizations have specific regulations and standards that require the control of screen reflectivity to ensure the health and safety of the users and workers. By using anti-reflective technology, Surface devices can help meet these standards, contributing to a safer and more comfortable working environment.

Designing for innovation in anti-reflective technology

Designing the AR coating for Surface devices was not a simple task. We aimed to reduce reflections in a meaningful way without sacrificing picture quality and brightness or compromising the user experience. It involved multiple rounds of trials, tests and evaluations, with different suppliers, materials and processes. We had to consider many factors, such as the optical performance, the reliability, the process control, the yield and cost. We also had to consider the impact of the AR coating on the other components of the display, such as the black mask, IR ink, touch layers, polarizer, adhesives and the display panel itself.

We started by defining the target specifications for the AR coating, based on a benchmark analysis and user studies of multiple AR solutions. Our goal was to reduce overall reflectance by 50% and improve transmittance at the glass level. We also wanted neutral reflection for all light sources and a high transmission in the IR spectrum range for the Windows Hello feature. Balancing all aspects of the displays was essential for delivering a premium experience.

Once the target outcome was identified, we worked closely with our manufacturer to align their AR coating designs with our specifications and verify their performance at both the cover glass level and touchscreen display module (TDM) levels. We used different equipment and materials to deposit the AR coating on the glass surface. We also applied an anti-fingerprint (AF) coating over the AR coating to protect it from scratches and abrasion.

We measured and evaluated the optical and reliability performance of the AR-coated cover glass and TDM samples, using various methods. We assessed reflection color, reflection intensity and transmission as well as evaluating the impact of the AR coating on the IR ink and various cameras/sensors. Reliability tests such as abrasion, adhesion, chemical resistance, thermal shock, humidity and UV exposure ensured the AR coating met our quality standards. Finally, we conducted user studies and demos to assess the visual experience and gather feedback.

Results you can see

We’ve created an incredible experience that allows users to be more productive in almost any lighting condition.

Reduced reflections: Our advanced anti-reflective technology reduces reflections by up to 50%, making it easier to see your screen in bright light or even outdoors. This ensures that your work is always readable, no matter where you are.
Individually calibrated displays: Each Surface Pro 10 and Surface Laptop 6 display is individually calibrated to minimize unwanted reflections while preserving exceptional picture quality. This attention to detail ensures touch and pen interactions remain precise and responsive, providing a seamless user experience.
Enhanced brightness and contrast: Surface Pro 10 features our latest PixelSense display, which is 33% brighter and boasts a 15% higher contrast ratio than its predecessor, the Surface Pro 9. With support for brightness levels ranging from 2 to 600 NITS, users can enjoy vibrant visuals in any lighting condition.
Certified excellence: Our displays have been certified by TÜV SÜD, a globally recognized testing and certification organization, to meet the stringent requirements of ISO 9241-307, which ensures high-quality display performance and user safety.1
Eye comfort and longevity:  To improve eye comfort, we’ve engineered the displays on Surface Pro 10 and Surface Laptop 6 to reduce blue light exposure. This not only improves eye comfort but also allows users to work longer without experiencing eye strain. Our displays are certified by TÜV SÜD for their low blue light ratio, ensuring a healthier viewing experience.1
Flicker-free experience: Additionally, our displays have been rigorously tested to be flicker-free, further enhancing eye comfort and reducing eye strain. This certification by TÜV SÜD underscores our dedication to user well-being.1

At Surface, we are committed to creating premium hardware and experiences that enable our customers to work more efficiently and comfortably. The displays on Surface Pro 10 for Business and Surface Laptop 6 for Business are not only stunning and responsive, but also designed to reduce eye strain, glare and reflections in any lighting condition. We achieve this by applying advanced anti-reflective technologies and by individually calibrating each display to ensure optimal picture quality. Our displays have been certified by TÜV SÜD for their flicker-free, low blue light and high-quality performance, demonstrating our adherence to rigorous industry standards.

With our displays, you can focus on what matters most, without being distracted or fatigued by your screen. For more information, head to the links below:

Surface Pro 10
Surface Laptop 6

Make sure to subscribe to the Surface IT Pro Blog and come back to discover more about our innovative designs that boost productivity and elevate user experience.

References

1. Testing and certification has been performed by TÜV SÜD and only applies to Surface Pro 10 for Business and Surface Laptop 6 for Business.

​Microsoft Tech Community – Latest Blogs –Read More 

Hi all,

I’m creating a list for RCCA items and NCRs and need to have a column titled “NCR Number” to auto populate with a unique number based on the manufacturing plant selected. I’ve created a simple flow that does this using the ID that’s already being created in the background, but it’s not exactly what I need.

We already have an NCR library for both of our manufacturing plants in the form of excel lists and word documents, and the numbering system is unique for each plant (i.e. MN859 and MA732, where ‘MN’ and ‘MA’ are the prefixes for our plants). Is there a way to do this in one list on a Sharepoint site and continue the current numerical values?

​Hi all, I’m creating a list for RCCA items and NCRs and need to have a column titled “NCR Number” to auto populate with a unique number based on the manufacturing plant selected. I’ve created a simple flow that does this using the ID that’s already being created in the background, but it’s not exactly what I need. We already have an NCR library for both of our manufacturing plants in the form of excel lists and word documents, and the numbering system is unique for each plant (i.e. MN859 and MA732, where ‘MN’ and ‘MA’ are the prefixes for our plants). Is there a way to do this in one list on a Sharepoint site and continue the current numerical values?  Read More

​

Hi, 

I recorded a Macro creating a Pivot table. It works fine into my computer, but when I send the file to another computer, the arrangement of the pivot table fields showed differently.

 have 3 Sheets, data, Pivot & Summary. I changed the field setting into “show item labels in tabular form” & “Repeat item labels” when I recorded the Macro. The Pivot messed up, so the Summary messed up too because it was connected to Pivot.

Is there a way to fix the Pivot when I run the Macro into another computer? 

Below is part of the Macro the arranged the fields:

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
“Wall Panel_1!R2C1:R” & LastRow & “C9”, Version:=8).CreatePivotTable TableDestination:= _
“Pivot!R3C1″, TableName:=”PivotTable3”, DefaultVersion:=8

Sheets(“Pivot”).Select
Cells(3, 1).Select

With ActiveSheet.PivotTables(“PivotTable3”).PivotCache
.RefreshOnFileOpen = False
.MissingItemsLimit = xlMissingItemsDefault
End With
ActiveSheet.PivotTables(“PivotTable3”).RepeatAllLabels 2
With ActiveSheet.PivotTables(“PivotTable3”).PivotFields(“PANEL LOCATION”)
.Orientation = xlRowField
.Position = 1
End With
ActiveSheet.PivotTables(“PivotTable3”).AddDataField ActiveSheet.PivotTables( _
“PivotTable3”).PivotFields(“COUNT”), “Sum of COUNT”, xlSum
With ActiveSheet.PivotTables(“PivotTable3”).PivotFields(“PANEL LENGTH”)
.Orientation = xlRowField
.Position = 2
End With

​Hi,  I recorded a Macro creating a Pivot table. It works fine into my computer, but when I send the file to another computer, the arrangement of the pivot table fields showed differently. have 3 Sheets, data, Pivot & Summary. I changed the field setting into “show item labels in tabular form” & “Repeat item labels” when I recorded the Macro. The Pivot messed up, so the Summary messed up too because it was connected to Pivot. Is there a way to fix the Pivot when I run the Macro into another computer?  Below is part of the Macro the arranged the fields: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _”Wall Panel_1!R2C1:R” & LastRow & “C9″, Version:=8).CreatePivotTable TableDestination:= _”Pivot!R3C1″, TableName:=”PivotTable3”, DefaultVersion:=8Sheets(“Pivot”).SelectCells(3, 1).SelectWith ActiveSheet.PivotTables(“PivotTable3”).PivotCache.RefreshOnFileOpen = False.MissingItemsLimit = xlMissingItemsDefaultEnd WithActiveSheet.PivotTables(“PivotTable3”).RepeatAllLabels 2With ActiveSheet.PivotTables(“PivotTable3”).PivotFields(“PANEL LOCATION”).Orientation = xlRowField.Position = 1End WithActiveSheet.PivotTables(“PivotTable3″).AddDataField ActiveSheet.PivotTables( _”PivotTable3”).PivotFields(“COUNT”), “Sum of COUNT”, xlSumWith ActiveSheet.PivotTables(“PivotTable3”).PivotFields(“PANEL LENGTH”).Orientation = xlRowField.Position = 2End With   Read More

​